Report Builder

Report Builder has an intuitive and familiar user interface which allows you to start creating reports quickly. 
Report Builder can be downloaded from the Microsoft website and installed to be used by itself, to run reports against a SQL server database instance or in conjunction with a reporting services server.

To begin launch Report Builder 3.0 and By default the Getting Started dialog is displayed immediately:

Note: The Getting Started dialog is always displayed when you start Report Builder unless you click the "Don't show this dialog box at startup" checkbox in the bottom left corner of the dialog.  If the Getting Started dialog isn't displayed on startup, you can go to the Report Builder Options and choose to display it on startup (we'll cover Report Builder Options later in this tutorial).

The Getting Started dialog is only displayed right after you launch Report Builder.  After you make a selection from the Getting Started dialog or close it, you cannot get back to it.  You can display the New Report or Dataset dialog which contains essentially the same options as the Getting Started dialog by clicking on the main menu icon on the top left corner of the report builder menu bar and clicking on the new option.

Creating New Reports

The New Report option in both the "Getting started" and "New report and dataset" dialogs allow you to choose a wizard or a blank report as your starting point.  The wizards walk you through creating a report in a sequence of steps. 
click on "Table or matrix wizard" option to start creating a report.

you will be prompted to choose a data set. If you are already working on or editing a report and are trying to create another report in the same project you can choose the dataset used in the project, but if this is a new report then you will have to click on the "Create dataset" option and then click on the next button.

In the next screen you will be asked to provide a data source(SQL server instance or reporting services server) if you already have an instance that you want to use you can browse to its location and choose it, if not then you can create one by clicking on the "New" button.

In this screen you will have to create a connection to the database instance. click on build to create a new connection string.

Enter the details of the database that you would like to use as your data source for the reports into the appropriate boxes and click the Ok button.

after clicking on the ok button in the connection properties the connection string generated will populate the connection string box in the data source properties window.

Now that you have set up the connection to the server you can click ok and a data source for the report will be created and added to the data source connections window in the new table or matrix wizard. choose the new data source and click next.