COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: mycognos on 30 Oct 2008 04:48:06 AM

Title: No rows returned
Post by: mycognos on 30 Oct 2008 04:48:06 AM
I have a report, in which I want to display a message if the query does not return any data. How can I handle this in cognos8.3?

Have implemented this in cognos 8.2 but it is not working in cognos8.3.
The following is the code used for the report expression in cognos8.2:

Case when (RowNumber() is NULL) then ('No Data for the Given Input') else ('') end
Title: Re: No rows returned
Post by: billylodz on 30 Oct 2008 10:27:29 AM
No Data Contents
Title: Re: No rows returned
Post by: mycognos on 04 Nov 2008 08:49:33 AM
hi..

We can hanle this in 8.3 using the property "No Data Contents".

http://support.cognos.com/opendocs/en/html/cognos8_bi/8.3/crn_nf_id1161no_data_hndlg.html

Thanks...