• Article

Exporting a Report as an XML File (Report Builder 1.0)

The XML file with report data export option saves a report as an XML file. The XML schema for the report is specific to the report, and contains data only. The report layout information is not saved by the XML export option. The XML generated using this option can be imported into a database, used as an XML data message, or sent to a custom application.

General Rules

The following table describes how report items appear when they have been exported to the XML file format.

Item

Display behavior

Report

Appears as the top-level element of the XML document.

Charts, Tables, Matrixes

Appear as an element within the element for its container.

Group and detail sections

Each instance appears as an element within the element for its container.

Text boxes

Appear as an attribute or element within its container.

Matrix column groups

Appear as elements within row groups.

Report data that is saved using the XML export option also have the following considerations:

  • XML elements and attributes are saved in the order that they appear in the report definition.

  • Pagination is ignored.

  • Images are ignored.

Data Types

The text box element or attribute is assigned an XML Schema definition language (XSD) data type based on the values that the text box displays.

If all text box values are:

Assigned data type is:

Int32

xsd:integer.

Decimal (or Decimal and any integer or byte data type)

xsd:decimal

Float (or Decimal and any integer or byte data type)

xsd:double

Double (or Decimal and any integer or byte data type)

xsd:double

DateTime

xsd:dateTime

Boolean

xsd:boolean

String, Char

xsd:string

Other

xsd:string

To better understand how the XML export option saves the Report Definition Language (RDL) elements in a report as a XML file, you might want to learn more about the elements. For more information about RDL elements, see the Report Definition Language topic in SQL Server Books Online.

In This Section

Topic

Description

RDL Elements and Attributes in XML (Report Builder 1.0)

Describes how each element in the report is saved by the XML export option.

Applying Transformations to XML Files (Report Builder 1.0)

Describes how to apply XSL Transformations (XSLT) to XML output.