If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

DYnamic page headers

Started by zenith, 20 Apr 2006 01:52:39 AM

Previous topic - Next topic

zenith

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

bdybldr

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.

zenith

hi i think i am applying the condition wrong
can u tell me when to exactly apply the conditonal ... in a sequence
Cheerss

bdybldr

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?

pg0816

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.