Exporting a Report as an XML File (Report Builder)
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 2005 Books Online.
In This Section
| Topic | Description |
|---|---|
Describes how each element in the report is saved by the XML export option. |
|
Describes how to apply XSL Transformations (XSLT) to XML output. |
See Also
Tasks
How to: Export a Report as a Different File Type (Report Builder)
Concepts
Exporting a Report as a Different File Type (Report Builder)
Design Considerations for Exporting a Report as a Different File Type (Report Builder)