Skip Headers
Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports
11g Release 1 (11.1.1)

Part Number B32122-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

45 Building a Report with an XML Pluggable Data Source

In this chapter, you will learn about reports that include data from an XML pluggable data source (PDS), which is provided with Oracle Reports. By following the steps in this chapter, you can generate the report output shown in Figure 45-1.

Figure 45-1 Report output using an XML PDS

Description of Figure 45-1 follows
Description of "Figure 45-1 Report output using an XML PDS"

Concepts

Example Scenario

In this example, you have an international business with warehouses in the United States and overseas. These warehouses are running a decentralized management system that stores the operational data locally at each site. The inventory of the warehouses are managed by the local managers. However, for planning purposes, a team at corporate headquarters needs to access the inventory data (in SQL), including the most recent data, of every warehouse. The warehouse data is only available as an XML stream. You will learn how to combine data from a local database (that is, the warehouse data) and data from an XML feed to create a Web report. You will use static XML files that are provided.

As you build this example report, you will:

To see a sample report that uses an XML PDS, open the examples folder named xml_pds, then open inventory_report.rdf. For details on how to open it, see "Accessing the Example Reports" in the Preface. The example files used in this chapter are listed and described in Table 45-1.

Table 45-1 Example report files

File Description

xml_pds\inventory_report.pdf

The final PDF version of the paper report.

xml_pds\inventory_report.rdf

The final RDF version of the paper report.

xml_pds\xmlpds_sql.txt

The various SQL statements you will use in this report.

xml_pds\warehouse_inventory.xml

The XML data source for the query in your report.

xml_pds\warehouse_inventory.xsd

The XML data stream for your report.