45.4 Summary

Congratulations! You have successfully used an XML data source for a paper report. You now know how to:

  • create a SQL query from scratch.

  • use the Data Wizard to create an XML query.

  • create a data link between a SQL query and an XML query.

  • create a layout for your report using the Report Wizard.

  • apply alternating row colors to your report using format triggers and procedures.

  • filter your XML data using a group filter and hierarchy.

For more information on any of the wizards, views, or properties used in this example, refer to the Oracle Reports online Help, which is available in Oracle Reports Builder or hosted on the Oracle Technology Network (OTN), as described in Section 4.1.1, "Using the Oracle Reports online Help".