Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
SQL Server Reporting Services provides several approaches for authoring and deploying paginated reports. Learn how to plan a report authoring and report server environment that work together.
This article is 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 - Business Intelligence projects, and in Report Builder. RDLC files are authored by using the ReportViewer controls that are included in Visual Studio.
The following table lists each available schema version and the abbreviation that is used throughout the rest of this article:
Abbreviation | Schema version |
---|---|
2016 RDL | https://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition |
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 on RDL and RDL schemas, see the following resources:
For more information about ReportViewer controls, see ReportViewer controls (Visual Studio).
A report definition file can be deployed to a SQL Server 2016 (13.x) Reporting Services or later (SSRS) report server in the following ways:
Report Designer: Deploy a report from Report Designer in SQL Server Data Tools - Business Intelligence.
Report Builder: Save a report to the report server from Report Builder.
Web Portal: Upload a report to a native mode report server from the web portal.
The following table lists the supported rdl schema version by version of the report server.
Report server version | RDL schema version |
---|---|
SQL Server 2016 | 2016 RDL 2010 RDL 2008 RDL 2005 RDL 2000 RDL |
SQL Server 2014 (12.x) Or SQL Server 2012 (11.x) Or SQL Server 2008 R2 (10.50.x) |
2010 RDL 2008 RDL 2005 RDL 2000 RDL |
SQL Server 2008 (10.0.x) | 2008 RDL 2005 RDL 2000 RDL |
When you upload a report definition to the report server or upgrade a report server that contains existing reports, 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 (.rdl) itself isn't upgraded.
You can extract from the report server a read-only copy of the report definition file (.rdl). On a native mode report server, browse to the web portal, select the report and choose Download.
In a SharePoint mode deployment, browse to the document library, select the report and choose Download a Copy.
To upgrade the report definition, you must open the report in a report authoring environment, such as SQL Server Data Tools or Report Builder, and then save it.
For more information about report upgrades and the schema versions that are supported, see Upgrade reports (SSRS).
Report authoring environments are Report Designer in SQL Server Data Tools - Business Intelligence projects, and Report Builder. Report authoring environments provide various support for reports like:
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 |
---|---|---|---|
SQL Server 2016 Report Builder | Authors 2016 RDL Will upgrade older RDL versions to 2016 RDL |
2016 RDL | SQL Server 2016 |
Report Designer in SQL Server 2016 Data Tools - Business Intelligence for Microsoft Visual Studio 2015 | Authors 2016 RDL Will upgrade older RDL versions to 2016 RDL |
2016 RDL | SQL Server 2016 |
Report Designer in SQL Server 2014 Data Tools - Business Intelligence for Microsoft Visual Studio 2012 Or Report Designer in SQL Server 2012 Data Tools - Business Intelligence for Microsoft Visual Studio 2012 Or Report Designer in SQL Server 2012 (11.x) Data Tools, included in SQL Server 2012 (11.x). |
Authors 2010 RDL Will upgrade older RDL versions to 2010 RDL |
2010 RDL | SQL Server 2014 (12.x) SQL Server 2012 (11.x) SQL Server 2008 R2 (10.50.x) |
Report Designer in SQL Server 2008 R2 (10.50.x) Business Intelligence Development Studio | Authors 2010 RDL Will upgrade older RDL versions to 2010 RDL |
2010 RDL | SQL Server 2008 R2 (10.50.x) |
Report Designer in SQL Server 2008 (10.0.x) Business Intelligence Development Studio | Authors 2008 RDL Will upgrade older RDL versions to 2008 RDL |
2008 RDL | SQL Server 2008 (10.0.x) |
For more information on SQL Server Data Tools (SSDT), see the following resources:
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 2015 Or 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 resources:
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Build reports for finance and operations apps - Training
Organizations have a lot of data. When an organization grows, its ability to provide context for all that data becomes increasingly crucial. Reports can organize data in a meaningful way. Finance and operations apps include reporting tools to help you create reports for your organizations, SQL Server Reporting Services (SSRS), Microsoft Power BI, and Microsoft Excel reports. You can use these reporting tools to visualize a data set in many ways, including as a tabular layout with collapsible tables and by u
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Documentation
See how to use Report Designer in SQL Server Reporting Services to create full-featured paginated reports and reporting solutions.
Report Parts in Report Designer - Microsoft Report Builder & Power BI Report Builder
Publish paginated report items separately to a report server or SharePoint site so that you and others can reuse them in other reports in Report Builder.
Add a new or existing report to a report project - SQL Server Reporting Services (SSRS)
Learn how to add a new or existing report to a report project by using the Report Wizard in SQL Server Reporting Services.