COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: wyconian on 16 Nov 2011 11:40:27 AM

Title: Display Blank Queries
Post by: wyconian on 16 Nov 2011 11:40:27 AM
Hey everyone

My client has a list report being exported to excel.  The report has mulitple queries used as multiple lists on one report page.  The queries have filters.  Some of the queries don't return any data becuase there is nothing that meets the filter selection criteria but.  The client wants to display zeros for the queries that don't return any data. 

I'm at a bit of a loss on how to do that.  Any ideas?

As always millionm thanks for any help you can give ;)

Wyconian
Title: Re: Display Blank Queries
Post by: pricter on 16 Nov 2011 12:09:07 PM
In version 8.4 there is a property of the list "No Data Contents"
If you set this property to yes you can you specify on this tab what to show when there is no data. When set to No, the tab is hidden and the query frame reverts to the default behavior.
Is this what r looking for?
Title: Re: Display Blank Queries
Post by: wyconian on 18 Nov 2011 11:18:04 AM
That is exactly what I needed thanks very much :-)