Plan for Report Design and Report Deployment (SSRS 2012)
SQL Server Reporting Services provides several approaches for authoring and deploying reports. This topic provides an overview of report definition support by Reporting Services components. A report definition is an XML file that is written in the Report Definition Language (RDL) or the Report Definition Language for Clients (RDLC). Each report definition conforms to a specific schema version that is listed at the beginning of the file.
RDL files are authored in Report Designer in SQL Server Data Tools (SSDT) projects, and in Report Builder. RDLC files are authored by using the ReportViewer controls that are included in Visual Studio 2005 and Visual Studio 2008.
Use this topic to help plan for a report authoring environment and report server that work together. This topic provides the following information:
In this Topic:
RDL Schema Versions
Report Server and RDL Schema Support
Report Authoring and Deployment Support
ReportViewer Controls
RDL Schema Versions
The following table lists each available schema version and the abbreviation that is used throughout the rest of this topic:
Abbreviation |
Schema version |
|---|---|
2010 RDL |
https://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition |
2008 RDL |
https://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition |
2005 RDL 2005 RDLC |
https://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition |
2000 RDL |
https://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition |
For more information about specific RDL schemas, see Microsoft SQL Server XML Schemas and Report Definition Language Specifications.
For more information about ReportViewer controls, see ReportViewer Controls (Visual Studio).
Report Server and RDL Schema Support
On a SQL Server 2012 Reporting Services (SSRS) report server, you can publish report definition files in the following ways:
Report Designer: Deploy a report from Report Designer in SQL Server Data Tools (SSDT).
Report Builder: Save a report to the report server from Report Builder.
Report Manager: Upload a report to a native mode report server from Report Manager.
SharePoint: Upload a report to a SharePoint site that is configured with a SharePoint mode report server.
Programmatically: Programmatically publish a report by using the SOAP API interfaces to a report server. For more information, see Report Server Web Service.
The following table lists support for report definition schemas by report server version.
Report server version |
RDL schema version |
|---|---|
SQL Server 2012 |
|
SQL Server 2008 R2 |
|
SQL Server 2008 |
|
When you upload a report definition to the report server by using Report Manager, the report server preserves the report definition in the original format. On first use, the report server upgrades the report in the report server database to a binary format that is preserved for subsequent views. The report definition itself is not upgraded. From Report Manager on the General Properties page for the report, you can extract a read-only copy of the report definition in the original format. For more information, see How to: Extract, Update, or Edit the Source File of a Published Model or Report Definition (Report Manager).
[!UWAGA]
To upgrade the report definition, you must open the report in a report authoring environment and then save it.
For more information about report upgrades and the schema versions that are supported, see Upgrading Reports.
Report Authoring and Deployment Support
Report authoring environments are Report Designer in SQL Server Data Tools - Business Intelligence projects, and Report Builder. Report authoring environments provide a variety of support for report upgrade, report design, report preview in local mode, report preview on the report server, and report deployment.
The following table summarizes support for authoring and deploying report definitions for different schema versions:
Authoring environment |
RDL version Authored |
Deploy RDL version |
Deploy to report server versions |
|---|---|---|---|
Report Designer in SQL Server 2012 Data Tools - Business Intelligence for Microsoft Visual Studio 2012, on Microsoft download center. Or Report Designer in Data Tools, included in . |
Authors 2010 RDL On open of existing RDL:
|
2008 RDL 2010 RDL |
SQL Server 2012 SQL Server 2008 R2 |
Report Designer in SQL Server 2008 R2 Business Intelligence Development Studio |
Authors 2010 RDL On open of existing RDL:
|
2008 RDL 2010 RDL |
SQL Server 2008 R2 |
Report Designer in SQL Server 2008 Business Intelligence Development Studio |
Authors 2008 RDL On open of existing RDL:
|
2008 RDL |
SQL Server 2008 |
SQL Server 2012 Report Builder |
Authors 2010 RDL On open of existing RDL:
|
2010 RDL |
Reporting Services SQL Server 2012 Reporting Services SQL Server 2008 R2Reporting Services |
Visual Studio RDLC Report Designer Report Designer |
2005 RDLC |
N/A |
N/A |
For more information on SQL Server Data Tools - Business Intelligence for Visual Studio 2013, see the following:
Deployment and Version Support in SQL Server Data Tools (SSRS)
Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012.
.gif "Ikona strzałki używana z łączem Powrót na górę strony")
Top
ReportViewer Controls
A Visual Studio ReportViewer control can display an .rdlc report in local preview mode or in remote mode, the control can display an .rdl file hosted on a Reporting Services report server. The following table provides the list of RDL versions supported by the ReportViewer controls for local processing (.rdlc). Server side RDL support is summarized in the section Report Server and RDL Schema Support.
ReportViewer control in product |
Version of RDL for local preview |
|---|---|
Visual Studio 2013 Or Visual Studio 2012 Or Visual Studio 2010 |
2008 RDL |
Visual Studio 2005 Or Visual Studio 2008 |
2005 RDL |
For more information, see the following:
Zobacz także
Koncepcje
Report Definition Language (SSRS)
Inne zasoby
Raporty, składniki Report Part i definicje raportów (program Report Builder i usługi SSRS)