Publish Reports

FromSQL Server Data Tools (SSDT), you can publish either all the reports and shared data sources in a Report Server project to a report server by deploying the project, or you can publish a single report. Before you can publish a report you must specify the URL of the target report server. For more information, see Set Deployment Properties (Reporting Services).

You can use the SQL Server 2008 R2 version of SQL Server Data Tools (SSDT) to open, modify, preview, save, and publish both SQL Server 2005 Reporting Services (SSRS) and SQL Server 2008 Reporting Services (SSRS) reports. For more information, see Deployment and Version Support in SQL Server Data Tools (SSRS).

To publish all reports in a project

• On the Build menu, click Deploy <report project name>. Alternatively, in Solution Explorer, right-click the report project and then 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.

To publish a single report

• In Solution Explorer, right-click the report and then click Deploy. You can view the status of the publishing process in the Output window.

  Note

  When you publish a report, you must also deploy the shared data sources that the report uses.

See Also

Publishing Data Sources and Reports
Previewing Reports
Publishing Reports to a Report Server
Finding, Viewing, and Managing Reports (Report Builder and SSRS )
Exporting Reports (Report Builder and SSRS)