COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ravindravoggu on 10 Jan 2010 06:23:23 AM

Title: Supress Zero rows in row and column level in Cross tab report (Cube data source)
Post by: ravindravoggu on 10 Jan 2010 06:23:23 AM
Hi All,

I have one report that is having Anaysis code which is given prompt in the  Data item level
[Analsysis code] -> ?Analysis code?. Then i want to display in the prompt as optional but it is taking as requried. And i have one column for this report as Entity and measure as Activity B1/ Activity B2 based on the selection in the prompt page. So i have to hide the zero rows and columns. Could any one plelase help us out in thei scenrio,s where i can resolve this issue.


Thanks in Advance.
Ravindra..