Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Find the Report Definition Schema Version (SSRS)

A report definition file specifies the RDL namespace for the version of the report definition schema that is used to validate the rdl file. When you open an .rdl file in a report authoring environment such as Report Designer in SQL Server Data Tools (SSDT) or Report Builder, if the report was created for a previous namespace, a backup file is automatically created, and the report is upgraded to the current namespace. If you save the upgraded report definition, you have saved the converted .rdl file. This is the only way to upgrade a report definition. The report definition itself is not upgraded on a report server. The compiled report is upgraded on a report server. For more information, see Upgrade Reports.

How to: Identify the RDL Schema Version of a Report

  • Open the report .rdl file in an application such as Notepad or XML Notepad 2007 in which you can view the xml.

    The XML Report element specifies the schema namespace. For example, the following Report element specifies the namespace for Report Designer and the namespace for the report definition.

    <Report xmlns:rd=http://schemas.microsoft.com/SQLServer/reporting/reportdesigner 
    xmlns="http://schemas.microsoft.com/sqlserver/reporting/2009/01/reportdefinition">
    

    The report definition namespace is specified by the following URL: http://schemas.microsoft.com/sqlserver/reporting/2009/01/reportdefinition.

How to: Identify the RDL Schema Version of Report Designer

  1. Open a new project. The version of the project that you choose determines the version of the RDL schema. In SQL Server 2012, more than one schema version is supported. For more information, see Deployment and Version Support in SQL Server Data Tools (SSRS).

  2. On the Project menu, click Add New Item. The Add New Item dialog box opens.

  3. In the Templates pane, click Report.

  4. In Name, type a report name or accept the default.

  5. Click Add. Report Designer opens a new blank report in Design view.

  6. On the View menu, click Code. The report definition is displayed as an XML file.

    The XML Report element specifies the schema namespace. For example, the following Report element specifies the namespace for Report Designer and the namespace for the report definition.

    <Report xmlns:rd=http://schemas.microsoft.com/SQLServer/reporting/reportdesigner
    xmlns="http://schemas.microsoft.com/sqlserver/reporting/2009/01/reportdefinition">
    

    The report definition namespace is specified by the following URL: http://schemas.microsoft.com/sqlserver/reporting/2009/01/reportdefinition

How to: Identify the RDL Schema Version on the Report Server

  • In Report Manager, type the URL for the report server. For example, the following URL specifies a report server on the local computer:

    http://localhost/reportserver/reportdefinition.xsd

    The .xsd file opens in the browser.

    The XML schema element specifies the schema namespace. For example, the following schema element specifies three namespaces: the targetNamespace reference that is used internally by Visual Studio, the xsd reference for the schema itself (xsd), and the report definition reference. 

    <xsd:schema 
    targetNamespace="http://schemas.microsoft.com/sqlserver/reporting/2009/01/reportdefinition" 
    xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
    xmlns="http://schemas.microsoft.com/sqlserver/reporting/2009/01/reportdefinition" 
    elementFormDefault="qualified">
    

    The report definition namespace is specified by the following URL: http://schemas.microsoft.com/sqlserver/reporting/2009/01/reportdefinition

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.