If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to not suppress repeating group elements in crosstab in RS?

Started by brain1e55, 16 May 2006 07:21:09 AM

Previous topic - Next topic

brain1e55

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!

LSPENNER

I AM ATTEMPTING TO DO THE EXACT SAME THING!!!  IF YOU GET A RESPONSE PLEASE LET ME KNOW.

decuser

Can you set the LevelSpan Property on the outlet column to none?

brain1e55

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.

decuser

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