Struggling with trying to exclude a column from a list report if it contains all zero values. Example
Item #sold #purchased #delivered #donated
123 4 3 0 8
456 2 8 0 5
789 1 1 0 3
In the above list report I would like it to exclude the #delivered column from the report as all of the values=0. If I ran the same report tomorrow and the there was a delivered item I would want the column to show Using Cognos 10 report studio, prefer not to have to convert to crosstab unless absolutely necessary. Any suggestions?
Quote from: dbowen1 on 15 Aug 2014 02:27:16 PM
Struggling with trying to exclude a column from a list report if it contains all zero values. Example
Item #sold #purchased #delivered #donated
123 4 3 0 8
456 2 8 0 5
789 1 1 0 3
In the above list report I would like it to exclude the #delivered column from the report as all of the values=0. If I ran the same report tomorrow and the there was a delivered item I would want the column to show Using Cognos 10 report studio, prefer not to have to convert to crosstab unless absolutely necessary. Any suggestions?
Hi,
You could conditionally hide the column if the total is zero? Would that work for you?
Cheers!
MF.