Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Print Object On dilema

15046Jan 17 2003 — edited Jan 20 2003

I have one Master query Say MQ1 and two detail queries say DQ1 and DQ2. For any instance of MQ1 the DQ1 and DQ2 can return 0..n records.
In my lay out. I have

|----MQ1--------------------|
|data data data |
| |
| |---DQ1---| |---DQ2---| |
| | Data | |Data | |
| |---------| |---------| |
| |
|---------------------------|

I have set all the objects in MQ1 to be printed on "ALL Pages" and it works no problems here. The problem is with the out frame of DQ1 and DQ2. Each can print only 5 records in the space provided. IF I set both to be "ALL Pages" The the report never get passed page 1 for each MQ1, even If there are more than 5 records on either of DQ1 or DQ2. If I set it to be "FIRST PAGE", The report do go to muliple pages for MQ1. IF there are 13 records for DQ1 and only 2 for DQ2 Report show all 3 pages. The problem is It does not repeat headings for DQ2 on subsiquent pages. That area becomes blank. IF I set the fram property to "FISRT PAGE" for DQ1 and "ALL PAGES" to DQ2, The report produces required results for MQ1 records with multipage output for DQ1 and all column headings repeated for DQ2. But if number of records on DQ2 are more than 5 a[i]

Long postings are being truncated to ~1 kB at this time.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 17 2003
Added on Jan 17 2003
1 comment
175 views