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.

Figure 14. Viewing the report. Click image for full-size screen shot.

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

Summary

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.