Page 1 of 1
Print ' no data found' in oracle reports?
Posted: Wed Feb 28, 2007 5:16 am
by 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
Posted: Tue Apr 10, 2007 4:53 am
by 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
Posted: Fri Apr 13, 2007 2:08 am
by kishorebabu
hi,Zafar Iqbal
very thanks for ur help
thanks & regards
j.kishorebabu
Posted: Tue Apr 24, 2007 9:16 am
by riv_sax
yes the answer given is right but use it in before report trigger as the message will be displayed earlier
rivon saxon
Posted: Wed May 16, 2007 9:15 am
by 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
Posted: Sat Jun 02, 2007 8:09 am
by 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