|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:
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:
|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.