Print ' no data found' in oracle reports?

[kishorebabu]

can any one help me, if there is no data in my querry then print ' no data found' and also user name in oracle report ,how can i display this messgae and user name

[zafarkarachi]

Hi Dear,

I know this is a very late reply.

but i u dont have the solution yet then use the
following code under After parameter form trigger.

Example :

function AfterPForm return boolean is
dn number;
begin
select distinct deptno
into dn
from emp
where deptno = :dno;

Return(true) ;

exception
when others then
srw.message(01403,'Sorry! No data found ...');
-- return(true) ;
raise srw.program_abort ;

end;

Regards
Zafar Iqbal
0321-2876518

[kishorebabu]

hi,Zafar Iqbal

very thanks for ur help

thanks & regards
j.kishorebabu

[riv_sax]

yes the answer given is right but use it in before report trigger as the message will be displayed earlier


rivon saxon

[bhaskar_j22]

1) take a summary column then find the count in that by selecting a column from table
2) go to layout editor and then place a boiler plate text and write "no_data_found"in that
3) right click that boiler plate text and open pl/sql editor
4)write the code as

if :summary_column =0 then
return (true)
else
return(false);
end if;

hope this works

[punithavel]

The nice one by Baskar is

<i> 1) take a summary column then find the count in that by selecting a column from table
2) go to layout editor and then place a boiler plate text and write "no_data_found"in that
3) right click that boiler plate text and open pl/sql editor
4)write the code as

if :summary_column =0 then
return (true)
else
return(false);
end if;
</i>

It is working fine and thanks for the logic