A script-enabled browser is required for this page to function properly.

Generating XML output

In any Oracle Reports-generated XML file, your output mimics the data model; that is, it is structured by groups and columns. Follow the steps below to do any of the following:

To generate an XML output file from your current report in Reports Builder:

  1. (Optional) In the Object Navigator, select or open the report, then click the Run Paper Layout button in the toolbar to run the report. Currently, any report style can be generated to XML output, but with limited support for matrix-style reports.

  2. (Optional) In the Paper Design view, choose Fileright arrowPreview Formatright arrowXML to preview XML data in your default XML viewer (for example, your Web browser).

    Tip: An .XML extension is required by XML-supporting browsers to recognize the format as XML and display it accordingly.

  3. Click the report in the Object Navigator and choose Fileright arrowGenerate to Fileright arrowXML to save the XML output file to the directory of your choice.

To generate an XML output file from the command line, then preview the contents of the XML file in a Web browser:

  1. On the command line, run your report with the arguments DESFORMAT=XML, DESTYPE=FILE, and DESNAME=filename.XML.

  2. Open an XML-supporting Web browser.

  3. Choose Fileright arrowOpen to navigate to the XML file that you just generated, and display it in the browser window.

  4. If you make changes to the XML output or regenerate the XML file with the same name, click the Reload button in your browser to view the updated XML output.

To change the XML properties of the entire report:

  1. In the Object Navigator, double-click the Properties icon next to the report name to display the Property Inspector.

  2. Under XML Settings, set the XML properties as required for this report.

To change the XML properties of a column or group:

  1. In the Data Model view, double-click the column or the title bar of the group to display the Property Inspector.

  2. Under XML Settings, set the XML properties as required.

Usage notes

See also

About XML in reports

Oracle Reports XML tags

The chapters "Creating Advanced Distributions" and "Customizing Reports with XML" in the OracleAS Reports Services Publishing Reports to the Web manual, available on the Oracle Technology Network Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html).

Running and dispatching a report from the user interface

Running a report from the command line

Running a report using a command file

Running a report to a remote Reports Server

Generating HTML or HTMLCSS output

Generating PDF output

Generating RTF output

Generating text output

Generating delimited output

Generating spreadsheet output

Distributing a report to multiple destinations

Deploying a report