Home » Developer & Programmer » Reports & Discoverer » Anyway to stop report in Before-Report Trigger (Oracle Report Builder 10g, Win XP)
Anyway to stop report in Before-Report Trigger [message #517184] Sun, 24 July 2011 01:57 Go to next message
new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar
Senior Member
Is there any way of stopping the report from executing in Before-Report Trigger.

Actually what i am doing is to see whether some records are present there in the table in Before-Report Trigger on which the report is going to print. Because I am doing some updates in After-Report trigger. I want to stop if there is no records present in the table in Before-Report Trigger so the report will not go forward to After-Trigger of the report.

If possible please let me know how to stop and by using which statement. If not please let me know the other way so that if report has no data then After-Report Trigger should not fired.
Re: Anyway to stop report in Before-Report Trigger [message #517185 is a reply to message #517184] Sun, 24 July 2011 02:03 Go to previous messageGo to next message
Littlefoot
Messages: 19521
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check the SRW built-in in Reports Help. Two options I can think of are SRW.BREAK and SRW.PROGRAM_ABORT.
Re: Anyway to stop report in Before-Report Trigger [message #517191 is a reply to message #517185] Sun, 24 July 2011 03:38 Go to previous message
new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar
Senior Member
Thanks friend
Previous Topic: Analyzing Reports complexity / find particular function in reports
Next Topic: Migrate from reports 6i to reports 11g
Goto Forum:
  


Current Time: Thu Aug 28 18:58:44 CDT 2014

Total time taken to generate the page: 0.14686 seconds