Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 311 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 117 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to handle blank reports to printer or e-mail
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
Answers
-
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
0