Appendix C: Report Definition Language Reference


Report Definition Language

The Report Definition Language (RDL) is an XML structure defined by Microsoft for storing Reporting Services reports. RDL is an element-centric XML structure. That is to say, RDL primarily uses elements to store information, rather than attributes.

The two types of elements within RDL are parent elements and property elements. Parent elements contain other elements, whereas property elements define a property of the parent element. The name of the property is the same as the name of the element. The value of the property is the contents of the element. For example, if the LeftMargin property of the report is set to 1 inch, the element containing that property would look like this:

<LeftMargin>1in</LeftMargin>

Property elements do not contain other elements.

Default Values

In order to keep the RDL files from becoming unwieldy, properties that are set to a default value will not be included in the RDL file. For example, the default value for the PageHeight property of a report is 11 inches. If the PageHeight of a report is set to 11 inches, the RDL file for that report will not contain a PageHeight element. The programs that read (or consume) the RDL file need to know these default values and fill them in automatically.

RDL Structure

Note

In the following illustrations, the single arrows indicate a one-to-zero-or-one relation between the parent element and the child element. For example, the Report element may contain zero or one PageHeader elements. The arrows with shading indicate a one-to-zero-or-many relation between the parent element and the child elements. For example, the DataSources element may contain zero or many DataSource elements.

Report

The entire report definition is contained within the Report element. The structure of the parent elements within the Report element is shown here:

click to expand

ReportItems

The report layout is made up of report items. As you saw in the previous illustration, report items can be placed in the PageHeader, the Body, and the PageFooter elements. The structure of the parent elements within the ReportItems element is shown here:

click to expand

The structure of each of the data regions is shown in the following sections.

Table

The structure of the parent elements within the Table element is shown here:

click to expand

Matrix

The structure of the parent elements within the Matrix element is shown here:

click to expand

List

The structure of the parent elements within the List element is shown here:

Chart

The structure of the parent elements—Chart, Axis, and ChartSeries—within the Chart element is shown here and on the following page:

click to expand

click to expand

Grouping, Sorting, and Style

Last, but not least, the structure of the Grouping, Sorting, and Style elements is shown here:

click to expand

These items are used within a number of the other elements.




Microsoft SQL Server 2000 Reporting Services
Microsoft SQL Server 2000 Reporting Services Step by Step (Pro-Step by Step Developer)
ISBN: 0735621063
EAN: 2147483647
Year: 2003
Pages: 109

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net