You deploy reports to SSRS to make them accessible to anyone using a Web browser. Reporting Center allows you to configure SSRS from the Reporting Center Console, without opening SSRS. There are a number of deployment options, such as running the report on a schedule, delivering deployed reports to a file share or an email address, and automatically refreshing the report when data changes. You deploy a report from the Deploy Report wizard, which you access from the Report ribbon in the Reporting Center Console. You can also deploy multiple reports using the Deploy Bulk Reports option in the Quick Access Tool bar.
After you have deployed a report, Reporting Center automatically deploys changes when you save or run the report in the Console. It is not necessary to manually redeploy a report each time you modify it in the Console, unless you set up a subscription for the report. In that case, when you modify the report in the Console, you must redeploy the report once to reset the subscription. If you delete a deployed report from the Console, it is also deleted from SSRS.
NOTE:To deploy reports from Reporting Center, you must have permission to deploy a report from the Console and you must configure the correct permissions in SSRS. In addition, to take advantage of the email delivery option, you must configure email settings in SSRS. For more information, see Section 2.4, Configuring SQL Server Reporting Services.
Before you deploy reports to SSRS, consider the following:
For reports deployed using Microsoft SQL Server 2008 Reporting Services, the deployed report does not display the grid lines and tick marks configured in the Reporting Center Console. You configure grid lines and tick marks in the Properties dialog boxes for the X-Axis, Primary Y-Axis, and Secondary Y-Axis.
SSRS does not support the Forecast report property. Consequently, reports configured in Reporting Center using Forecast does not display the forecasted data series.
SSRS does not support the Data Point Marker Step report property. When you configure a data point step for markers on a data series, the value of the step is always 1 in SSRS, regardless of the actual value you set the Reporting Center Console before deploying the report. For more information, see Report Definition Language.
In the Deploy Report wizard, if you configure the report to automatically refresh at regular intervals, and then you modify the report in the Console, the next time SSRS tries to refresh the report, it returns the following error:
An error occurred during client rendering. An error has occurred during report processing. The data source ‘DataSourceName’ cannot be found.
To refresh the report, click F5 in the browser. SSRS resumes the auto-refresh at the intervals specified in the Deploy Report wizard.
After you have saved a report, you can deploy it to SSRS.
To deploy a report to SSRS and view the deployed report:
From the Reports tab, click Deployment > Deploy Report.
Enter information in the Deploy Report wizard. For more information about the wizard, see the Help.
Click Finish.
To view the deployed report, go to a Web browser and type the following URL:
http:// ServerName /Reports
Click the deployed report.
You can deploy multiple reports to SSRS:
From Quick Access Tool bar, click Deploy Bulk Reports.
In the Bulk Report Deployment, select the required reports.
Select the SQL Server Reporting Services URL. If you want to validate the URL that you have selected, click Validate. To add a new URL of a SQL Server Reporting Server, click AddNewLocation.
Click Deploy Selected.
After deployment is successful, close the Bulk Report Deployment.