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

How to create render variable.

Started by jd, 11 Dec 2009 02:11:45 PM

Previous topic - Next topic

jd

hi,

I have to display No Data text when report does not have any records. I created render variable and assigned to the block. but when I am running the report it is saying invalid variable

please can anyone help me?

sag4cognos

Hello Laxmi,

I am not sure which version of Cognos you are using, but from 8.2 ( i guess) Cognos has this new feature called No Data Contents. You would have to select either the cross tab or the list and on Conditional property, you will find No Data Contents.

Set that to Yes and you can add any text item or any other list in that place.

HTH,
Sagar

Sarayucog

Hi Lakshmi,

In Cognos 8.4 Version they have given nodata as a property.

for that just select the total report from Ancestor button, and go to the properties under Conditional there is a property called No data Contents make it as YES then it will givesyou a page right to the report in the layout.

Then drag and drop one Text Item into that and write ur Custom message like "There is no data available to your responce".

Then run the report. Thats it.

It will helps to you. and let me know which version you are using now.

Sarayu.


jd

Thanks Saray,

No data Contents is working for my issue.  just wondering why my render variable is not working.

I created dataitem Row Count = count ([Document Number] for report)
created boolean variable [Row Count] is missing
created No data text item in list footer
assigned render variable to text item. when I run the report, if there are no records it is not showing No data mesage.
if you have any idea where and what I am missing, Please cn ayou let me know.

Thanks for your help.