Skip to content

Latest commit

 

History

History
73 lines (48 loc) · 3.99 KB

File metadata and controls

73 lines (48 loc) · 3.99 KB
title Updating Reports Using Classes Generated from the RDL Schema (SSRS Tutorial) | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology reporting-services-native
ms.topic conceptual
helpviewer_keywords
RDL [Reporting Services], generating
RDL [Reporting Services], tutorials
RDL [Reporting Services], serializing
ms.assetid 8f81d48f-7ab9-4ef8-bce0-7d16d9a47fbd
author markingmyname
ms.author maghan
manager kfile

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 [!INCLUDEmsCoName] [!INCLUDEdnprdnshort] xref:System.Xml.Serialization.XmlSerializer class.

What You Will Learn

During the course of this tutorial, you will complete the following activities:

  • Create an application using the [!INCLUDEmsCoName] [!INCLUDEvsprvs] 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:

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#)

See Also

Report Definition Language (SSRS)