Using the SQL Server 2000 Reporting Services
Pages: 1, 2
Deploying the Report
Before you 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 (see Figure 12).
Figure 12. Specifying the server to deploy your report
To deploy the report, press
F5. In your web browser, you will see the list of reports published by the current project (see Figure 13). Here, there are three reports (the first two were created prior to this current report): Report1, Report2, and TitlesReport. To view the new report, click TitlesReport.
Figure 13. The deployed reports
You should now be able to view the report (see Figure 14). Click on the
+ sign to expand the list of books under a particular type.
What's cool about the SQL Server 2000 Reporting Services is that you can also export the report to various file formats. My personal favorite is the PDF option (see Figure 15).
Figure 15. Exporting the report to other file formats
In this article, I have briefly shown you the steps to create a report using the SQL Server 2000 Reporting Services. Using the wizard, you can create a new report quickly and easily without much effort. While this is useful for beginners, you should really explore the other features of the Report Designer to customize the format of your report as you become familiar with how the Report Designer works.
In the next article, I will discuss how you can integrate reports into your .NET applications.
Wei-Meng Lee (Microsoft MVP) http://weimenglee.blogspot.com is a technologist and founder of Developer Learning Solutions http://www.developerlearningsolutions.com, a technology company specializing in hands-on training on the latest Microsoft technologies.
Return to ONDotnet.com.