How to abort the report execution

[SumithaTheivendran]

Dear all,
I need to abort the report execution,if the query generating report returns no rows.I tried to do this using the report trigger 'before report'.I have written code like this
Function BEF_REP_TRG return boolean is
count_inv number;
begin
select count(*) into count_inv from invoices
where _invoices = invoiceno;
if count_inv = 0 then
srw.message (1009, 'No invoices')
return false;
end if;
return true;
end;
But ,it is displaying a dialog box saying rep-1825 Before Report trigger returned false .
If anyone knows ,why it happens like this means,pls let me know.
Thanks in advance

 

[pfonseca]

Just a wild guess, but try the SRW package (?)

 

[holgerheck]

Hi Sumitha,

I have the same problem as you have.
Did you find a solution yet?

Thanks.