Share via


Deployment and Version Support in SQL Server Data Tools (SSRS)

SQL Server Data Tools supports the following scenarios:

  • Open report definitions (*.rdl) and report server projects (*.rptproj).

  • Build report definitions.

  • Preview reports in Report Designer.

  • Deploy reports to report servers.

Configuration and Deployment Properties

SQL Server Data Tools (SSDT) supports project configurations. A project configuration consists of a set of properties that specify locations and behaviors when a project is built either as a step in previewing or deploying reports. To learn more about project configurations, see the Visual Studio documentation.

Use project configurations to control the upgrade of report definitions to schema versions compatible with target report servers. The properties controlled by project configurations include the target report server, the folder where the build process temporarily stores report definitions for preview and deployment, and error levels.

Reports are built before they are rendered as previews in Report Designer or deployed to the report server.

You set the configuration properties in the SQL Server Data Tools (SSDT) Project Property dialog box.

The build and deployment properties include:

  • OutputPath is a build property that identifies the path of folders to store the report definition used in build verification, deployment, and preview of reports.

  • ErrorLevel is a build property that identifies the severity of the build issues that are reported as errors. Issues with severity levels less than or equal to the value of ErrorLevel are reported as errors; otherwise, the issues are reported as warnings. For more information, see The "Report Validation and Error Levels" section in Design Reports with Report Designer (SSRS).

  • TargetServerVersion is a deployment property that identifies the expected version of SQL Server Reporting Services that is installed on the target report server specified in the TargetServerURL property.

When you specify the earlier version of SQL Server Reporting Services in the Project Property dialog box, the reports are not reverted automatically to the earlier version. As such, a Report Server project can contain reports from the two different versions of SQL Server. When the Report Server project is deployed, all reports in the project are converted to the version specified in TargetServerVersion.

You can add more than one project configuration to a project; each one is used for a different scenario, such as deploying to different versions of report servers. For more information, see Set Deployment Properties (Reporting Services) and Project Property Pages Dialog Box.

Supported Versions

Note

SQL Server Data Tools (SSDT), the 32-bit development environment for Report Server projects, is not designed to run on Itanium-based computers and is not installed on Itanium-based servers. However, support for SQL Server Data Tools is available for x64-based computers.

The following table describes the supported versions for authoring and publishing reports in SQL Server Data Tools (SSDT).

Note

The schema has not changed since SQL Server 2008.

Project or File type Version Author Reports Publish Reports Notes
Report Server Project

or

Report Server Wizard Project
SQL Server 2014 2014 RDL schema SQL Server 2014 Reporting Services
Report Server Project

or

Report Server Wizard Project
SQL Server 2012 2012 RDL schema SQL Server 2012 Reporting Services
Report Server Project

or

Report Server Wizard Project
SQL Server 2008 R2 2008 R2 RDL schema SQL Server 2008 R2 Reporting Services
Report Server Project

or

Report Server Wizard Project
SQL Server 2008 2008 RDL schema SQL Server 2008 Reporting Services report server only Upgrades 2003 RDL and 2005 RDL to the 2008 RDL schema locally.
Report Server Project

or

Report Server Wizard Project
SQL Server 2005 2005 RDL schema SQL Server 2005 or SQL Server 2008 Reporting Services report server
Report Server Project SQL Server 2000 2003 RDL schema Not supported
Visual Studio RDLC Report Designer Visual Studio 2005

Visual Studio 2008
2005 RDL schema Not supported Does not support 2008 RDL schema.
Visual Studio Viewer controls Visual Studio 2005

Visual Studio 2008
2008 RDL not supported in local mode N/A Can view 2008 RDL reports on SQL Server 2008 Reporting Services report server in server mode.

For more information about opening reports in a previous version of the report definition schema, see Upgrade Reports. For more information about specific report definition schemas, see Report Definition Language Specification.

See Also

Publishing Data Sources and Reports