To Do this
Start the Report Project Wizard Start a new project in Visual Studio and select Report Project Wizard from the Business Intelligence Projects folder. You must provide a name for the project and solution, and designate a folder location for the solution.
Add a data source using the Report Wizard Go to the "Select the Data Source" page; enter a name for the data source; select a connection type; and enter a connection string, such as:

data source=localhost;initial catalog=rs2000sbsDW
You could generate the connection string automatically by using the Edit button to access the Data Link Properties dialog box.
Add a query string using the Report Wizard Go to the "Design the Query" page; enter or paste in a query string, or click the Edit button to open the Query Builder.
Select a report type using the Report Wizard Go to the "Select the Report Type" page; click either the Tabular or Matrix option.
Arrange the data using the Report Wizard Go to the "Design the Table" page, assign fields to the Page, Group, and Details sections. Then go to the "Design the Matrix" table; assign fields to the Page, Columns, Rows, and Details sections.
Select a table layout using the Report Wizard Go to the "Choose the Table Layout" page; select Block or Stepped, or optionally include subtotals. If you choose the stepped layout, you can enable drilldown.
Apply a style template using the Report Wizard Go to the "Choose the Table Style" page or the "Choose the Matrix Style" page; click a style name. A preview of the style will be displayed.
Assign a deployment location and a report name using the Report Wizard Go to the "Choose the Deployment Location" page; enter the URL for the Report Server to host the report. For example:

http://localhost/ReportServer.
Optionally, enter a folder name. The folder will be created on deployment if it does not already exist. This page requires a report name.
Preview a report Go to Visual Studio; click the Preview tab.
Adjust the size of a column in a table Go to Visual Studio; click the table to display the column and row handles. Then drag the column handle to the left to make the column smaller or to the right to make it larger.
Publish a report solution Go to the Build menu of Visual Studio; click Deploy Solution.
Open Report Manager Enter the URL in your browser, such as:
http://localhost/Reports
View a report Go to the Report Manager; navigate the folder hierarchy to the report, and then click the report link.
Manage report properties Open the report in Report Manager; click the Properties tab. Use the applicable link in the left frame to access the set of properties to be managed. Set a property by clicking an option or selecting a check box, then clicking the Apply button.
Export a report Open the report in Report Manager; select the export format from the list box and click the Export link.

Table 1 Build SQL Server Reports.
A lot of what you do isn't visible to end users—but not reports. Here's where your users see what you do the most, and they always want more. So wipe out that backlog of report requests by using SQL Server Report Designer's wizards. Here's a quick summary of how to use them to crank out reports and modify existing ones.