Print Page - hide rows based on condition

Title: hide rows based on condition
Post by: juffin on 24 Jan 2014 10:03:59 PM

I have a report which has columns A and B
Column A is grouped and Column B has numeric values
A total(sum of column B) is made for each group(column A)
My question is once a total is zero for a group
entire group should not be displayed in the report.

Column A Column B
-----------------------
A -10
     -20
     +30
total 0
-----------------------
B      +10
     -20
     +5
total -5
-----------------------

only group B should be displayed in the report..

Thanks in adv for any ideas...
jf

Title: Re: hide rows based on condition
Post by: MFGF on 25 Jan 2014 11:52:19 AM

Hi,

Retrieving then hiding these rows seems like an inefficient way to achieve your requirement. It would be more efficient and far easier to code a summary filter with the expression [Column B] > 0 and with the Scope setting defined as Column A.

Cheers!

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: juffin on 24 Jan 2014 10:03:59 PM