Print ' no data found' in oracle reports?
-
- Posts: 16
- Joined: Fri Feb 09, 2007 7:19 am
- Location: India
Print ' no data found' in oracle reports?
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
-
- Posts: 22
- Joined: Sat Dec 16, 2006 6:35 am
- Location: Pakistan
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
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
-
- Posts: 16
- Joined: Fri Feb 09, 2007 7:19 am
- Location: India
-
- Posts: 2
- Joined: Wed Dec 13, 2006 3:01 am
- Location: India
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
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
-
- Posts: 4
- Joined: Wed Nov 08, 2006 6:15 am
- Location: India
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
<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
Who is online
Users browsing this forum: No registered users and 5 guests