Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Publish Reports

From SQL 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 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 Note

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.