This article tries to cover the basics of creating a report using SQL Server 2000's Reporting services. The following are the steps to do so
- If SQL 2000 Reporting Services is installed with Visual Studio .NET 2003 and SQL Server 2000 Service Pack 3, you will see a project type in Visual Studio .NET 2003: Business Intelligence Projects. There are two templates available: Report Project Wizard and Report Project.
- Select the Report Project template and name it "MyReport." Click OK
- In Solution Explorer, you will see two folders: Shared Data Sources and Reports under the MyReport project. We will create a report using the Pubs database; now right-click on the Shared Data Sources folder and select Add New Data Source.
- In the Data Link Properties dialog box, enter the details required, like Server Name, User Id, Password and Select database.
- Now, In Solution Explorer, right-click on Reports and select Add New Report. Use the wizard to add new report.
- Select the shared data source you configured in the earlier step and click on Next Button.
- Use the Query Builder or type in the SQL string manually to get the data for the report and click on Next Button.
- Select the report type, i.e Tabular or Matrix. Select Tabular and click on Next Button.
- In the next dialog, you will choose the various fields listed in the left list box for the report. To assign a field to the relevant section of the report, select the particular field and click Page>, Group>, or Details> Button and click on Next Button.
- Choose the table layout and Style in next dialog box.
- Finally, give a name to your report, say "MyFirstReport" and click Finish.
- To deploy your report for the first time, you need to configure the target server for hosting your report.
- In Solution Explorer, right-click on the Project name and select Properties. In the TargetServerURL field, specify the location of your Report Manager, which is by default http://localhost/ReportServer
- To deploy the report, press F5. In the web browser, you will see the Name of your report i.e. "MyFirstReport"
- To view the report Click on the name of your report, i.e. "MyFirstReport"
|
| Author: Bachan rawat 23 Jul 2008 | Member Level: Silver Points : 1 |
good artical,
can you post such a artical with sqlserver 2005 and asp.net 2005.
i apresiate ur artical.
|