COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Martin_HH on 05 Feb 2009 03:05:40 AM

Title: Problem with BOX TYPE: NONE
Post by: Martin_HH on 05 Feb 2009 03:05:40 AM
Hello everyone,

in my crosstab there is on the very left side the crosstab member 'Zeile', have a look at the attached picture.
I need that for sorting the following rows. 
But i dont want 'Zeile' to be shown in the report.
So i changed the type of the box to NONE. But that leads to formatting problems, everything moves to the left side, without the last column header 'Monat'.

Is there any other way of hiding that first member 'Zeile' ?? Or a way of solving the formatting problem i described?

Cognos Version is 8.4

Thanks for any help!
-martin
Title: Re: Problem with BOX TYPE: NONE
Post by: globalbear on 05 Feb 2009 04:30:27 AM
Add a sorting to the crosstab node member (not the crosstab node) 'Rubrik' - drag 'Zeile' to the detail sort list.

Then delete Zeile from the crosstab - this will delete Zeile from the page but not from the query becuause it is used by the detail sort list.

Rubrik is now sorted by Zeile but Zeile is not shown on the report.
Title: Re: Problem with BOX TYPE: NONE
Post by: Martin_HH on 05 Feb 2009 06:48:54 AM
Hi globalbear,

that was exactly what i needed. Thanks!

-martin