COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: WKar on 18 Mar 2009 01:56:50 PM

Title: Hide Data Items in Columns/Rows
Post by: WKar on 18 Mar 2009 01:56:50 PM
Hello,

In a lot of my reports I nest details underneath a data item, however, I dont want them seen on the report.  How do I hide them? 

Example of column

Month To Date
Revenue   (I want Revenue hidden since Revenue is in the title of the report)

Thank you!
Title: Re: Hide Data Items in Columns/Rows
Post by: blom0344 on 20 Mar 2009 04:58:38 AM
Did you try the class 'don't print'?
Title: Re: Hide Data Items in Columns/Rows
Post by: chris2001dc on 20 Mar 2009 09:09:06 AM
YOu could try in the properties "Box Type" = None another way
It's usinf the class "Don't print" but you need to configure in the properties the "Source Type" to text.

Title: Re: Hide Data Items in Columns/Rows
Post by: WKar on 20 Mar 2009 12:01:18 PM
I am not familar on how to try the class 'dont print'.  Where can I do this? 

I tried the box type = none just now, but what happens when i select box type none on a row item is it shifts my measures box to the left and then the measure intersection is not lined up with the columns. 

Then when i select box type = none for the column item (which is a data item not a member) It doesn't remove the box, particulary when I export to Excel.

Please Advise, its much appreciated!!!
Title: Re: Hide Data Items in Columns/Rows
Post by: WKar on 20 Mar 2009 01:15:06 PM
I found the classes property and selected dont print (source type = text)
and in Excel it doesnt hide the box.  I think I should clarify, I am trying to get the report to look proper in Excel.

This is what I have been doing is I changed the source type to "report expression" So it doesnt display anything. The issue is, it looks good when you run the report HTML, but when I export to Excel it has the boxes and they kill the look of the report. 

What else can I try?

Title: Re: Hide Data Items in Columns/Rows
Post by: chris2001dc on 20 Mar 2009 01:35:05 PM
Please review this post.

http://www.cognoise.com/community/index.php/topic,6192.0.html

You have to add a crosstab space for each box type=none to the right.