Building a Multi-table Report with SQL 2005 Reporting Services - Deploying the report on the Report Server
(Page 6 of 6 )
When you deploy the report on the Report Server, you will be giving web access to your reports. Since the data is coming from a SQL Server which requires SQL Server authentication, the report is available only to authenticated users. In order to deploy the report, right click on Report1.rdl and from the drop-down click on deploy. This brings up the Microsoft Report Designer message. This message says that the target server (Report Server on which this report must be placed) is not specified.
Click on the OK button to close out of this window. Highlight the Project in the solution explorer and right click to open the project's properties window as shown. Type in the URL as shown in the text box for the TargetServerURL.
The next picture shows the web server on which you may find this server. The report may be targeted to another server if you wish. For the RS, you may find two virtual directories. You may upload a report, or you may place the project on the Report Server.
By accessing the Home page of Reports$Mysorian you may upload the file using the Upload File button. The Report1 !New has been uploaded using this button.
If you click on Report1 !New it will open a screen where you need to provide the authentication information.
After the authentication you can click on the View Report button to open the report as shown, hosted on the Reports folder.
However if you successfully deploy the project, the project files, which may consist of other reports, will be hosted on the Report Server.
Summary
Details of creating a multi-table report using the SSRS have been described. The report accesses the Northwind database on the SQL 2005 server which requires SQL Server authentication. The built-in query designer is extremely user friendly. However, the query designer may not work the same way for non-Microsoft data sources. The formatting of the report is also facilitated by the extensive properties available for the controls in addition to the built-in styles. Microsoft's SQL Server Reporting Services makes rapid enterprise report creation and deployment a whole lot easier by the tight integration of its products.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
/ 13 
