Tutorial: Generating RDL Using the .NET Framework
This tutorial illustrates how to write Report Definition Language (RDL) to a report definition file using the System.Xml.XmlDocument class.,The XmlDocument class provides an XML document object model (DOM) you can use to quickly generate the data structure of an RDL, and helps you to build report definition documents that conform to the RDL specification.
If you need to write XML as raw data without the overhead of a DOM, you can use an System.Xml.XmlTextWriter. The writer provides a fast, forward-only way of generating XML. The System.Xml.XmlTextWriter writes to a stream rather than using an object model such as the XML DOM.
What You Will Learn
During the course of this tutorial, you will complete the following activities:
Create an application using the Visual Studio Console Application project template.
Add a connection to the AdventureWorks2008R2 sample database.
Write code to retrieve a list of fields for the data source.
Write code to generate a simple report definition file that can be used to build a report.
Requirements
To complete the tutorial, you must have the following:
Microsoft SQL Server 2008 R2 Reporting Services.
Microsoft Visual Studio 2008 or a similar Microsoft .NET Framework-compatible development tool.
The AdventureWorks2008R2 sample database installed to an instance of SQL Server. The samples are not installed automatically during setup, but you can install them at any time. For information about installing the samples, see Considerations for Installing SQL Server Samples and Sample Databases.
Estimated time to complete the tutorial: 60 minutes
Tasks
Lesson 1: Creating the RDL Generator Visual Studio Project
Lesson 2: Creating a Connection to the Sample Database
Lesson 3: Retrieving a List of Fields for the Report Definition
Lesson 4: Creating Code to Generate the Report Definition File
Lesson 5: Running the RDL Generator Application (VB/C#)
Note
When reviewing tutorials, it is recommended you add next and previous buttons to the document viewer toolbar. For more information, see Adding Next and Previous Buttons to Help.