[RS]Sectioning in crosstabs

[Taboka]

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

[Taboka]

Hi,

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

Regards

Taboka