Grouped crosstab

[lorisd38]

Hello, I have actually 2 Table Group in my report and I want to add a Crosstab iterate over the group.

I explain it :
In my dataSet I have 5 column, CODE, VALUE, X, Y, Z, and I have n CODE (A, B, C, etc...) and I have m VALUE (a, b, c, etc...).
X, Y and Z are coordinates for a 2D or 3D graph.
My first table group it's for CODE and my second for VALUE.

There is an example of my dataSet content for 3D and 2D :
CODE; VALUE; X; Y; Z
A; a; 1; 0; 0
A; a; 1; 1; 1
A; a; 1; 2; 0
A; b; 0; 0; 0
A; b; 0; 1; 1
A; c; 1; 0; null
A; c; 1; 2; null
A; d; 0; 0; null
A; d 0; 1; null
B; a; 1; 2; 2
B; a; 2; 2; 2
B; a; 2; 3; 2
B; b; -1; -2; 0
B; b; -2; 1.5; 1
B; b; 0; 0; 0
B; b; -1; 1; 1
B; c; 0; 0; null
B; c 0; 1; null

I use a filter to show crosstab for 3D and simple table for 2D.

For 2D table :
I only show X; Y value. Not CODE, VALUE or Z.
Actually when I setup my element in the table's detail, I have the correct result of each coordinates for each VALUE of each CODE.

For 3D crosstab :
I only show X; Y; Z value. Not CODE or VALUE.
Actually when I setup my Crosstab in my VALUE table group footer, I just have the same crosstab 4 times with the value for (CODE; VALUE) A; 1.

For the crosstab I place it in VALUE table group footer cause if I put it in the table's detail I have the crosstab which is repeated as many times as I have coordinates (X; Y; Z) for a pair (CODE; VALUE)

[lorisd38]

I find how to do it.