COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: zenith on 20 Apr 2006 01:52:39 AM

Title: DYnamic page headers
Post by: zenith on 20 Apr 2006 01:52:39 AM
hi

I have a problem. i need to display no data in the page header whenever theres no data in the list
I tried many ways using conditional text etc it dosent work howver
i also attached the query to the page i have a single query
Cheers
Title: Re: DYnamic page headers
Post by: bdybldr on 20 Apr 2006 07:32:51 AM
zenith,
Add a data item to your query (doesn't have to be displayed in the report) called "RowNum".Ã,  Define it as running-count(RowNum()).

Then create a boolean variable called "varNoRows" defined as [RowNum] < 1.

Add a conditional block to the header based on varNoRows and set current box to "Yes".Ã,  Then create a text item "No Data" and place it inside the conditional block.

I haven't tried this but it should work.Ã,  HTH

Keep us posted.
Title: Re: DYnamic page headers
Post by: zenith on 21 Apr 2006 03:28:25 AM
hi i think i am applying the condition wrong
can u tell me when to exactly apply the conditonal ... in a sequence
Cheerss
Title: Re: DYnamic page headers
Post by: bdybldr on 22 May 2006 09:41:45 AM
The sequence doesn't matter.  As long as you create your variables first, there should be no problem.  What is happening when you run the report?
Title: Re: DYnamic page headers
Post by: pg0816 on 10 Jun 2006 07:37:22 AM
zenith, did this work for you?
I am trying something similar.
I want to show a text message on the report when the report returns no data.


Thanks.