COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: Desperado on 03 Jun 2008 10:08:22 AM

Title: No Data found to be displayed for a section
Post by: Desperado on 03 Jun 2008 10:08:22 AM
Hi ALL,

I have to display "No data found" message if no rows are returned. I have seen the document in the support. But that is not solving my issue.

I have a section for the list. I'm setting up the No data found error message to be displayed. But the problem is if the section has no data, then i can just see the no data found message on the blank page  with out the list headers.

My requirement is i have to populate the list headers and the No data found message.

How should i do this ?
Title: Re: No Data found to be displayed for a section
Post by: blom0344 on 03 Jun 2008 02:25:18 PM
Apply a conditional renderer to the list headers that always defaults to true?
Title: Re: No Data found to be displayed for a section
Post by: Desperado on 03 Jun 2008 04:51:57 PM
My requirement is i have to display all the section headers, list headers and the no data found message.... I tried inserting a table and hard coding the details in it. But the client want the layout to be matching with the original layout with data.
Abt the conditional renderer, how do i use this? is this something to do with java scripting?
Thanks in Advance
Title: Re: No Data found to be displayed for a section
Post by: blom0344 on 04 Jun 2008 09:10:46 AM
No, this is not anything Java. You can define a Boolean variable (through insertable objects) and define this as a logical expression. (the outcome is either true or false/ yes/no)
In the list you can select the columnlist or list column title and apply the boolean variable in properties --> Text Source Variable
Title: Re: No Data found to be displayed for a section
Post by: Desperado on 06 Jun 2008 03:25:17 PM
I tried it. i created and expression rowcount =0 and applied it to the list column header text source variable. But i didn't get the list header displayed.

I feel that as there is a section, it is not showing up the list header part.

One method i did is, i created the same list and hard coded the section part and placed it in the no data found region that i'm displaying.
It's working.... But its a rough approach.
Even to do it with conditional block also, it takes lots of time.
I was thinking there might be some other way to do it. :(
thanks in Advance.