Updating Reports Using Classes Generated from the RDL Schema (SSRS Tutorial)
This tutorial illustrates how to use the XML Schema Definition Tool (Xsd.exe) to generate classes that allow you to serialize and deserialize report definition files (.rdl and .rdlc) with the Microsoft .NET Framework XmlSerializer class.
What You Will Learn
During the course of this tutorial, you will complete the following activities:
Create an application using the Microsoft Visual Studio Console Application project template.
Generate classes from the Report Definition Language (RDL) schema using the xsd tool.
Connect to a report server and retrieve a report definition.
Write code to update the report definition file.
Save the updated report definition back to the report server.
Run the RDL Schema Application (VB/C#).
Note
The code samples provided in this tutorial might fail for reports having no description. The failure is because the description property does not exist for the reports with description not specified.
Requirements
To complete the tutorial, you must have the following:
Microsoft Microsoft SQL Server 2014 Reporting Services.
Microsoft Visual Studio 2010.
Sufficient permissions to be able to access and publish reports to the Report Server Web service on the computer where your report server is located.
The AdventureWorks2012 sample database installed to an instance of SQL Server.
A report installed on your report server. This tutorial uses the sample report, Company Sales 2012. For more information about sample reports, see SQL Server Reporting Services Product Samples.
Note
The samples are not installed automatically during setup, but you can install them at any time. For information about samples, see SQL Server Product Samples.
Estimated time to complete the tutorial: 30 minutes
Tasks
Lesson 1: Create the RDL Schema Visual Studio Project
Lesson 2: Generate Classes from the RDL Schema using the xsd Tool
Lesson 3: Load a Report Definition from the Report Server
Lesson 4: Update the Report Definition Programmatically
Lesson 5: Publish the Report Definition to the Report Server
Lesson 6: Run the RDL Schema Application (VB-C#)