COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: brain1e55 on 16 May 2006 07:21:09 AM

Title: How to not suppress repeating group elements in crosstab in RS?
Post by: brain1e55 on 16 May 2006 07:21:09 AM
I have a dimensional datasource on which I build my crosstab report in Report Studio. The report sidehead contains 2 levels. Cognos shows it in the following way:

-------------------------------------
Outlet1Ã,  Ã,  Ã,  Ã,  | Manager1 |
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, | Manager2 |
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, | Manager3 |
------------------------------------
Outlet2Ã,  Ã,  Ã, Ã,  Ã, | Manager1 |
...
etc


But I need it to show in a different way, like this:

-------------------------------------
Outlet1Ã,  Ã, Ã,  Ã,  | Manager1 |
-------------------------------------
Outlet1Ã,  Ã,  Ã,  Ã, | Manager2 |
-------------------------------------
Outlet1Ã,  Ã,  Ã,  Ã, | Manager3 |
------------------------------------
Outlet2Ã,  Ã,  Ã,  Ã, | Manager1 |
...
etc


Is it possible or not?

Thanks in advance!
Title: Re: How to not suppress repeating group elements in crosstab in RS?
Post by: LSPENNER on 22 Jun 2006 10:24:59 PM
I AM ATTEMPTING TO DO THE EXACT SAME THING!!!  IF YOU GET A RESPONSE PLEASE LET ME KNOW.
Title: Re: How to not suppress repeating group elements in crosstab in RS?
Post by: decuser on 27 Jun 2006 11:06:54 AM
Can you set the LevelSpan Property on the outlet column to none?
Title: Re: How to not suppress repeating group elements in crosstab in RS?
Post by: brain1e55 on 28 Jun 2006 09:48:17 AM
Quote from: decuser on 27 Jun 2006 11:06:54 AM
Can you set the LevelSpan Property on the outlet column to none?

Where is this property resided? I can't find it.
Title: Re: How to not suppress repeating group elements in crosstab in RS?
Post by: decuser on 05 Jul 2006 03:56:32 PM
Hi,

Sorry I took so long to reply, these forums aren't the most intuitive to navigate....

Anyway, I think this property is only available in lists, not crosstabs, for whatever reason.

Will