Crosstab grouping

[Kevin]

Hi,

I have to develop a report who displays a crosstab.

Data are in the report's datasource and look like this :

ID    prevID     newID
1     toto          tata
2     toto          titi
3     toto          tutu
4     hello        hi
5     hello        bye

Data should be organize like this into the crosstab

toto     tata
           titi
           tutu
           total 3
hello    hi
           bye
           total 2
           TOTAL 5

If anyone can help me, I would be very gratefyl

Bye, Kévin

[Elian]

Hello Kevin,

The crosstab is used for grouping both on rows and columns, which suggests that the middle fields would be some kind of aggregates (Sum, Average, etc..)
The layout you want can be achieved with a simple table with one row group  on prevID containing the detailGroup. See attached image for more info

Regards,
Elian
the Telerik team