COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Taboka on 16 Aug 2007 02:51:36 AM

Title: [RS]Sectioning in crosstabs
Post by: Taboka on 16 Aug 2007 02:51:36 AM
Hi all,
I am trying to section my crosstab in eg the following manner,firstly by surname and then by name.However this is not working as i'd like for it to.Eg for the surname Smith I expect to see all names egJohn,James,Jesse and so on.What is actually happening is that I am seeing the one name for surname Smith and then the next section has a different surname and one name for it and so on.

I have checked my master-detail relationship and it is on the name item so I'm not sure what I'm missing.I hope someone can point me in the right direction.

Thanks\Regards

Taboka
Title: Re: [RS]Sectioning in crosstabs
Post by: Taboka on 27 Aug 2007 04:45:55 AM
Hi,

I managed to resolve this issue.I was not sorting properly and this is why I wasnt acheiving the desired result.

Regards

Taboka