The Repeat On property applies to the three sections of a report (Header, Main, and Trailer) and provides the ability to associate a data model group to a section. Setting the Repeat On property for a section enables you to obtain multiple instances of a section, or a repeating section. For example, you can set the Repeat On property for a section to the MANAGER data model group, which generates an instance of the section for each column of the MANAGER group. Then, you can distribute each instance of the section as appropriate (in this case, individual managers in the MANAGER group).
Applies to |
Sections |
Values |
Any group specified in the data model. |
Default |
Null |
Required/Optional |
Optional |
Setting Repeat On to an invalid group will result in a Cartesian product, which will be meaningless. To work correctly, set this property to the appropriate data model group.
If you set the Repeat On property for any combination of the Header, Main, and Trailer sections of a report, each Repeat On property must be set to the same data model group. If the Repeat On property for any section is set to a different data model group, Reports Builder displays any of the following messages:
REP-0069: Internal Error
REP-57054: In-Process job terminated: Terminated with error
REP-594: No report output generated.
For an example of using section-level distribution,
see the chapter "Bursting and Distributing a Report" 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
).
This chapter covers defining distribution of a single section to multiple destinations,
using the Repeat On property and distribution XML file.
Copyright © 1984, 2005, Oracle. All rights reserved.