tailieunhanh - Microsoft SQL Server 2005 Developer’s Guide- P40

Microsoft SQL Server 2005 Developer’s Guide- P40:SQL Server 2005 is a feature-rich release that provides a host of new tools and technologies for the database developer. This book is written to help database developers and DBAs become productive immediately with the new features and capabilities found in SQL Server 2005. | Chapter 9 Reporting Services 369 Click the Value drop-down box to list the fields available from the data source and select the field you want to relate to the report item. You can see in Figure 9-18 that the textbox1 item has been related to the field . After your report design is completed and the appropriate report items have been linked to fields in the data source you can select the Preview tab to render the report for you to view in the Report Designer s Preview window. When you are satisfied with your report design you can then generate and deploy your report to the Report Server. Deploying a Reporting Services Report After the report has been created the next step in creating a Reporting Services application is to build the report and deploy it to the Report Server. Building the report creates a .NET DLL assembly and deploying the report copies that assembly to the Reporting Services Report Server. You can deploy reporting solutions from the Report Designer by selecting the Build Deploy Reports option from the main menu. If you select one of the deployment options and the report has been changed the Report Designer will automatically build the report before it is deployed. The output from the build and deployment processes is shown in the Output window that you can see at the bottom of Figure 9-18. Any errors or problems will be listed in the window. Likewise if the report deployment succeeds then the success message is listed in the Output window. Running a Reporting Services Report Reporting Services reports can be run by accessing their URL through the Report Manager or by embedding them in your applications. You can access and run Reporting Services reports using the URL by pointing your browser to http servername reportserver where all of the Reporting Services reports and directories are listed. The ReportServer URL lists all of the reports that have been deployed to the Report Server. Each different solution is stored in its own .