 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
