For the purposes of this chapter, we have provided an RDF file you can use for bursting. In this section, you will set up the report for bursting by deleting the repeating frame and setting the Repeat On property of the Main section, so that the data bursts on each warehouse ID. This way, you can distribute the data for each warehouse as a report to the corresponding warehouse e-mail ID.
For more information on the Repeat On property, refer the Oracle Reports online Help.
In Reports Builder, choose File > Open.
Navigate to the directory where your examples source files are located, and open the file
The report displays in the Object Navigator.
In the Object Navigator, under the report name, double-click the view icon next to the Paper Layout node to display the Paper Layout view.
In the Paper Layout view, select the outermost repeating frame (R_G_WAREHOUSE_ID), then delete it.
For more information on frames and repeating frames, refer the Oracle Reports online Help.
In the Object Navigator, right-click the Main Section node, then choose Property Inspector to display the Property Inspector for the Main Section:
Under Section, set the Repeat On property to G_WAREHOUSE_ID.
Save the report as
You have set up your report to burst based on the warehouse ID.