COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: midhl on 24 Mar 2009 02:31:59 AM

Title: How to achieve group span in a cross tab
Post by: midhl on 24 Mar 2009 02:31:59 AM
Hi,
I am using a crosstab and using country and city as rows.By default
in a crosstab they are grouped .My requirement is they should'nt get grouped i.e for every city of a country the country should get repeated which can be achieved in a list using group span property.Any idea how to achieve it in a cross tab?
Thanks
Title: Re: How to achieve group span in a cross tab
Post by: rockytopmark on 24 Mar 2009 05:12:10 PM
You will need to Unlock the report...

Now you can simulate your list-like output you desire by building the 'columns' in the innermost row edge using tables (1 column for each row nesting), and then moving the outer nested row items into respected column in the table. 

Removing Classes from the Outer Row edges will make them basically disappear... you will have to play with the formatting to get it to look exactly how you want.