Exclude Columns with all Zero Values

[dbowen1]

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?

[MFGF]

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.