COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: bisslam on 31 Oct 2015 06:04:46 PM

Title: not to display the value of Query if it is zero,
Post by: bisslam on 31 Oct 2015 06:04:46 PM
Hello everyone,
I have a question please,
which setting is allowed not to display the value of query if it is zero,
Indeed, I rise to add two lines to a cell type of report (that is to say a request insert in each cell of the table) the existing cells do not display zero value while those I added displayed zero
thank you in advance
Ps:My table is not a table or a PivotTable list
Title: Re: not to display the value of Query if it is zero,
Post by: Francis aka khayman on 02 Nov 2015 12:11:59 AM
wow. sounds like you can write really good speeches.

how about describing to us what you are trying to do and the problem you encounter? it would help as well if you read the guidelines first in the sticky post
Title: Re: not to display the value of Query if it is zero,
Post by: sdf on 02 Nov 2015 10:04:22 PM
Hi bisslam,

We need to understand your question clearly. It would be better if you can explain a bit further regarding your requirement.
So you have a table, and you don't want zero values on your table cell?
QuotePs:My table is not a table or a PivotTable list
so what is it?
when you say
Quotenot to display the value of query if it is zero
are you pertaining to query expression?
where does the value for the cells comes from? data item? report expression?
If possible to share a screenshot of your report, it would be very helpful.
But take note on the rules on posting screenshots/attachments, you don't want to end up disclosing valuable company infos.



cheers!