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!

If no data, no report file. How to?

287291Jul 29 2002 — edited Feb 3 2006

Hi,

I have the following problem:
When my report is empty (no data returned in my ref cursor), the report header section is displayed
with an empty page from the main section.
I tried to apply formatting triggers on the fields/frames in order to hide them when the report is empty.
It's actually a little bit better as no field appear on the report but I still have 2 empty pages.
Is there any way to control how many rows my ref cursor contains and based on that "cancel" the report properly?

Thanks a lot,

Manu