How to handle blank reports to printer or e-mail

Tim Schoenberner

Summary

How to handle blank reports to printer or e-mail

Content

I have been successful in printing reports directly to a printer when the report runs (turns out it's simpler with a Postscript printer, to me).

The issue I'm having is when a report is blank when it doesn't select any records.  Now, it prints (or e-mails) a blank page.  Is there an easy way to prevent this( i.e. if no records are found, don't generate the print job or e-mail)?

I am currently using BIP 10g (I know,it's a little dated and I need to find the time to upgrade soon) so if it is better in subsequent releases, I'd like to know that as well.

Thanks,

Tim

Sherry George

Hi Tim,

user2759057 wrote:I am currently using BIP 10g (I know,it's a little dated and I need to find the time to upgrade soon) so if it is better in subsequent releases, I'd like to know that as well.

In 11g release (from 11.1.1.6) you can use event triggers. Check these links, maybe this is what you are looking for.

https://docs.oracle.com/cd/E23943_01/bi.1111/e22258/add_event_trig.htm#BIPDM331

https://docs.oracle.com/middleware/11119/bip/BIPUG/whatsnew.htm#CHDEEIIC