How to get the number of record fectched by query

[roseMay]

I have a report, user want it to popup a message if there is no records in this report, I'd like to perfome it using Before Report Trigger, but how could I get the number of record fectched by query?

Thanks a lot!

 

[nagornyi]

You will need to repeat the report query in the trigger and count its output into a variable. Something like;

function BeforeReport return boolean is
v_count Number:=0;
begin
select count(*) from
[b][the report query repeated here][/b]
into v_count;
  return (TRUE);
end;

 

[Petricia]

Hai,
U can add a summary field item and set its property to count of primary key field (or any field of not null data type) of the query.
ex. summary item name : cnt
set the properties of cnt as:
function : count
source : id (any not null column of the query)
resetat : Report

Now U can check the 'cnt' in the before trigger .