Home » Developer & Programmer » Forms » Starting Reports with Forms and suppress empty reports (Developer Suite, 10, Windows XP (server 2003))
icon8.gif  Starting Reports with Forms and suppress empty reports [message #598511] Tue, 15 October 2013 08:19
SIGGI
Messages: 1
Registered: October 2013
Location: Germany
Junior Member
Hello All.
I start in a Form a block of several printed reports and i like to supress empty reports when the report "no data found".
This i realized with srw.program_abort.

Unfortunately i get a Forms message (FRM-41214: Unable to run report)which i like to supress or i like to get a "finished" from the report server.
the user has to confirm every Forms Message(i do not like this).
I've checked :system.message_level := 25 and supressing empty pages in the report with no success.

any idea to solve this ?

## Form
...
...
v_rep := RUN_REPORT_OBJECT(repid);
--> v_rep gets the information "TERMINATED_WITH_ERROR"
--> after this line i get the Forms Message"FRM-41214: Unable to run report"
...
...

## report
--In BeforeReport i check the Main query

select count(*) into mnr
...
...

if mnr = 0 then
srw.message(100, 'No data to run report');
insert into qk_wasser_luft_failed_reports
...
...
standard.commit;
raise srw.program_abort;
return (false);
else
return (TRUE);
end if;
...
...

[Updated on: Wed, 16 October 2013 06:21]

Report message to a moderator

Previous Topic: how use parameters in form?
Next Topic: insert record into lov through oracle custom forms
Goto Forum:
  


Current Time: Tue Sep 23 19:56:35 CDT 2014

Total time taken to generate the page: 0.09795 seconds