How to prevent empty report generation in Oracle Report server(rwrun)

[sujincls]

Dear All,

It would be great if you can clearify my problem at the earliest.
I am using Oracle Report Server 9.2.0 to generate PDF reports. Sometimes if data is not found an empty report will be generated. I am trying to avoid empty report generation if data is not found. Can anyone tell me how to achieve this?

Report server is being called from a shell script. Is there any commandlie option to disbale this feature?

 

[BJCooperIT]

Have you tried using

SRW.PROGRAM_ABORT;

in a BEFORE REPORT trigger that determines there is no data?

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus