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

Creating an XML data source query using the Report Wizard

Accessing an XML data source does not require any database connection information as required for SQL queries.

To create an XML query using the Report Wizard:

  1. Launch Reports Builder (or, if already open, choose Fileright arrowNewright arrowReport).

  2. In the Welcome or New Report dialog box, select Use the Report Wizard, then click OK.

  3. If the Welcome page displays, click Next.

  4. On the Data Source page, click XML Query, then click Next.

  5. On the Data page, click Query Definition to display the Define XML Query dialog box.

  6. In the Define XML Query dialog box, click Browse next to Data Definition Location to select your data definition file location (DTD / XML Schema). You can also type the URL location containing your data definition.

  7. (Optional) Click Select Columns to display the Select Columns dialog box and select the columns you want to have in the query in your report.

  8. Click Browse next to Data Source Location to select your data source file. You can also type the URL location containing your XML data.

  9. If you want to validate the data source or specify an XSL, continue with Steps 10 through 12. If not, skip to Step 13.

  10. Click Show Advanced to extend the Define XML Query dialog box. You can click Hide Advanced to hide the advanced selection options.

  11. Check Validate Data Source if you want to validate your data source strictly against your data definition. If checked, the XML PDS will use the DOM parser internally. If you don't want to validate your data dource against your data definition, make sure that Validate Data source is not checked so that the XML PDS will use the SAX parser.

  12. (Optional) Specify the location of an XSL file by typing its URL. This is required if your Data Source XML is in a different format than the expected format for the XML PDS. This XSL file should contain the necessary transformation to convert your XML format to the expected format specified in About document type definition (DTD) formats.

  13. Click OK to close the dialog box and display your XML query in the Data Source definition field on the Data page of the Report Wizard.

  14. Follow the Report Wizard to complete your report definition.

See also

The chapter titled "Building a Report with an XML Pluggable Data Source" in the Oracle Reports Building Reports manual, available on the Oracle Technology Network Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html).