Deploy a Report Project (Azure SQL Reporting)
Updated: May 9, 2014
|SQL Reporting will discontinue service on October 31, 2014. See this FAQ for details. For reporting on Microsoft Azure, visit Virtual Machines on WindowsAzure.com.|
If you are using Report Designer in SQL Server Data Tools to author reports, you can deploy all the reports and shared data sources in a Report Server project to a SQL Reporting service by deploying the entire project, or individual reports or data sources in the project.
To learn more about other the deployment properties that you can set on Report Server projects, see Set Deployment Properties (Reporting Services).
For instructions on how to install SQL Server Data Tools, see Install SQL Server Data Tools to create reports on Azure.
Determine the web service URL. You will need to provide this URL as the target destination. For more information, see Run a Report (Azure SQL Reporting).
Verify permissions. You must be registered as Content Manager or Publisher to upload files to SQL Reporting.
In Solution Explorer, right-click the report project and click Properties.
In the Configuration list, select the deployment configuration that you want to use.
In OverwriteDataSources and OverwriteDatasets, select True to overwrite them on the server each time they are deployed or select False to keep the existing versions on the server.
In the TargetServerVersion list, verify that the value is set to SQL Server 2008 R2.
In TargetDataSourceFolder and TargetReportFolder, type the name of folder on the report server in which to deploy the report item.
If you leave the value of TargetDataSourceFolder blank, the data sources will be published to the location specified in TargetReportFolder. If TargetReportFolder is blank, reports and data sources are deployed to the root folder of the server.
Datasets and report parts cannot be managed directly on the SQL Reporting service and you need not provide values for TargetDatasets and TargetReportPartFolder.
In the TargetServerURL box, type the URL of the target SQL Reporting service. The syntax of the URL is https:// <ServerName>.reporting.windows.net/ReportServer.
In Solution Explorer, right-click the report project and click Deploy. You can view the status of the publishing process in the Output window.
Note When you deploy a Report Server project, the shared data sources in the report project are also deployed.
In Solution Explorer, right-click the report and click Deploy. You can view the status of the publishing process in the Output window.
Note When you publish a single report, you must also deploy the shared data sources that the report uses.
In Solution Explorer, right-click the data source and click Deploy. You can view the status of the publishing process in the Output window.