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!

Suppressing blank physical pages in a report

3238257Sep 6 2017 — edited Sep 11 2017

I have made a report  having one logical page (using the Reports Builder of Development Suite 9i). The report, at runtime, may expand to two physical pages or be just one physical page long depending on the choice of the value of a runtime parameter, according to which specific groups get selected from the data model.

Because the number of vertical panels per page had to be set at 2, two physical pages get printed even if the content is just one physical page long. The blank  second page could be removed by passing 'NO' for the 'BLANKPAGES' parameter from a form. However, if a field for numbering is introduced (source: physical pages or vertical panels) the second page is no longer considered a blank page and cannot therefore be removed using the aforementioned technique.

Is there a parameter that could reference the second physical page (which is blank, but for the page number field) so that a format trigger could be set to hide the page number on the second physical page, thereby facilitating the use of 'BLANKPAGES' parameter to hide the second physical page / panel?

Alternatively, is there any other workaround for the situation?

Thanks for your help.

Regards.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 9 2017
Added on Sep 6 2017
3 comments
720 views