OraFAQ Forum: Reports & Discoverer » display message in no data

Home » Developer & Programmer » Reports & Discoverer » display message in no data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

display message in no data [message #137145]

Tue, 13 September 2005 07:39

yogeshwar_cool
Messages: 32
Registered: July 2005
Location: india

Member

hi,
I want to show a message
if data group do not return any rows.

thanks and regards
yogeshwar.

Report message to a moderator

Re: display message in no data [message #138444 is a reply to message #137145]

Thu, 22 September 2005 01:16

justchakri
Messages: 27
Registered: September 2005
Location: Bangalore

Junior Member

Hi yogeshwar,

Take a formula column.

Select the count of one value (this should be not null value).

If COUNT(you want) is null

Return (Value/message);

end if;

Tahnks,
Chakri Smile

Report message to a moderator

Re: display message in no data [message #138544 is a reply to message #137145]

Thu, 22 September 2005 08:07

kiran
Messages: 503
Registered: July 2000

Senior Member

If my understanding is correct, you want to show a message when the total no.of records is zero.if so,you can write something like following.

Declare
num number;
Begin
select count(empno) into num from emp;
if num = 0 then
message('total Records are zero')
--or else you can define an alert and show it by using
-- show_alert() method.
end if;
End;

--Kiran.

Report message to a moderator

Previous Topic:	How do we customize the records of Tabular report?
Next Topic:	deploy reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 01 04:25:03 CDT 2024