Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Message box if No Data in report

Status
Not open for further replies.

rcaesar

MIS
Sep 5, 2002
92
US
Is there a way the user could be provided with a message like "There are no records for the dates entered" if the Report does not contain records for the filter.

Cognos' Knowledge Base tells us to use conditional formatting like insert a text box in the header, and then use an if statement like:

if (count(column name <> 0)

I only got that far. Since I am not sure what to use for the
"Then" part of the IF. Also Cognos forces you to use the Else. What would one use for the Else part?

Basically, like many others, I would like to give the user a message if there is an Empty Set or show the report when it is not.

I know you experts out there have some ideas. Can anyone suggest a solution.

Thanks a million

 
There's a very clear article in the latest Cognos Supportlink. It's even got a little video to show you what to do. Have a look at that.
Simon Rouse
 
Thanks DrSimon. I will certainly look at that.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top