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
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
raise srw.program_abort;
return (false);
return (TRUE);
end if;

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

Report message to a moderator

Previous Topic: How to copy image from one folder to another using Oracle Form 6i
Next Topic: How can i know what records are showed in data_block
Goto Forum:

Current Time: Thu Aug 24 05:49:27 CDT 2017

Total time taken to generate the page: 0.02896 seconds