COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: sujitgouda on 22 May 2014 01:02:20 PM

Title: Hiding Rows in Cognos Active Report.
Post by: sujitgouda on 22 May 2014 01:02:20 PM
I have a column with values; MF, MAGM, MAGS, MFM.
I want to toggle my list between values of MF and ALL( which is combination of MF, MAGM, MAGS, MFM).
I am using discret toggle to toggle between MF and ALL

I tried creating 2 new dataitems and working with them, but that doesn't help.
Is there a way I can suppress columns with Null or 0 Values ?

Can you guys please suggest something here.
Title: Re: Hiding Rows in Cognos Active Report.
Post by: MFGF on 22 May 2014 02:53:51 PM
Quote from: newb2cog on 22 May 2014 01:02:20 PM
I have a column with values; MF, MAGM, MAGS, MFM.
I want to toggle my list between values of MF and ALL( which is combination of MF, MAGM, MAGS, MFM).
I am using discret toggle to toggle between MF and ALL

I tried creating 2 new dataitems and working with them, but that doesn't help.
Is there a way I can suppress columns with Null or 0 Values ?

Can you guys please suggest something here.

Ok. I'm officially puzzled. Isn't this the exact same issue you raised and solved in this thread?

http://www.cognoise.com/index.php/topic,24769.msg78135.html#msg78135

MF.
Title: Re: Hiding Rows in Cognos Active Report.
Post by: sujitgouda on 22 May 2014 03:03:27 PM
Yep.
It worked earlier, but the size of the MHT file was getting bigger.
Fixed it via some smart logic  8)
Title: Re: Hiding Rows in Cognos Active Report.
Post by: MFGF on 22 May 2014 03:07:53 PM
Quote from: newb2cog on 22 May 2014 03:03:27 PM
Yep.
It worked earlier, but the size of the MHT file was getting bigger.
Fixed it via some smart logic  8)

So it's now fixed?
Title: Re: Hiding Rows in Cognos Active Report.
Post by: sujitgouda on 22 May 2014 03:29:55 PM
Yep, hence the thumbs up.