Home » Developer & Programmer » Reports & Discoverer » Display a message when report returns no data
Display a message when report returns no data [message #88070] Tue, 05 February 2002 17:38 Go to next message
Vijay Kumar Marada
Messages: 1
Registered: February 2002
Junior Member
Can any one help me to display a message "No data found" on blank page when the report returns no data?.. Thanks in advance
Re: Display a message when report returns no data [message #88076 is a reply to message #88070] Tue, 12 February 2002 07:33 Go to previous messageGo to next message
btaller
Messages: 2
Registered: February 2002
Junior Member
If there is no data then I assume you are getting a blank screen. Add some text on your report that reads no data found. Then add the format trigger to this text so that it only returns TRUE if the count for the query is zero.
Re: Display a message when report returns no data [message #221269 is a reply to message #88070] Mon, 26 February 2007 01:25 Go to previous message
archit_gaj
Messages: 9
Registered: February 2007
Location: Navi Mumbai
Junior Member
yes
u can write down the following code in main frame
u have one distinct number or first column

take one cf that will count that first_colum_name

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

this will work that is for i am sure.
Previous Topic: lexical parameters
Next Topic: Documents Extension..
Goto Forum:
  


Current Time: Tue Nov 26 16:22:28 CST 2024