Jaa


Applying Transformations to XML Files (Report Builder)

You can use the XML export option to produce XML files that can be transformed into almost any file type using XSLT transformations (XSLT). XSLT is code that translates the XML you exported into another format. You can use the XML export option and XSLT to produce formats that are not supported by Report Builder's export options.

There are three common scenarios in which you would use XSLT:

  • Data transfer   You can change the XML output from Report Builder into another XML format that can be read by another application, such as a database.
  • Text rendering   You can change an XML report into a plain text file.
  • HTML rendering   You can create HTML or other documents from an XML report.

The XML generated by the XML export option is specific to the report. Because of this, the XSLT that you use has to be specific to the report.

You can use Reporting Services or your own application to transform your XML report using XSLT.

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)
Exporting a Report as an XML File (Report Builder)

Help and Information

Getting SQL Server 2005 Assistance