Lesson 2: Generate Classes from the RDL Schema using the xsd Tool

 

Applies To: SQL Server 2016

After you have created your Visual Studio project, the next step is to retrieve a local copy of the report definition schema and run the XML Schema Definition Tool (Xsd.exe).

To generate the RDL classes

  1. Open an instance of Microsoft Internet Explorer (or equivalent Web browser) and navigate to the following URL:

    https://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition/ReportDefinition.xsd
    
  2. Once the RDL schema has been opened in the browser, browse to the File menu, and select Save As.

  3. Browse to the location where you created your Visual Studio project and save the schema with the file name ReportDefinition.xsd.

  4. After the file has been saved, open an instance of the Visual Studio 2010 command prompt. To open an instance of the command prompt, click the Start menu, point to All Programs, point to Microsoft Visual Studio 2010, point to Visual Studio Tools and click Visual Studio Command Prompt (2010).

  5. Change the current path to the location where you saved the ReportDefinition.xsd file:

    CD\<ReportDefinition.xsd Path>

  6. Generate the ReportDefinition.cs file that contains the classes for the RDL schema with the following command:

    xsd /c /n:SampleRDLSchema ReportDefinition.xsd

    To generate a ReportDefinition.vb file use this command:

    xsd /c /l:VB /n:SampleRDLSchema ReportDefinition.xsd

  7. Add ReportDefinition.xsd your project. From the Project menu, click Add Existing Item. Browse to the location of the ReportDefinition.xsd file, select ReportDefinition.xsd, and click Add.

    Note


    After you have added the ReportDefinition.xsd file to the project you will notice in Solution Explorer that the ReportDefinition.cs (.vb) file is not there. To display the file, click the expand/collapse button next to the ReportDefinition.xsd file.

Next Lesson

In the next lesson, you will write code to load a report definition from a report server using the classes you generated from the RDL schema. See Lesson 3: Load a Report Definition from the Report Server.

See Also

Updating Reports Using Classes Generated from the RDL Schema (SSRS Tutorial)
Report Definition Language (SSRS)