hello,
I need an help with another aspect of crosstab.
Indeed in this attachments you will see the crosstab that I created.
The thing is that i want to order the "... niveau 8"
Actually, report studio order by alphabeticaly but i dont want this.
For exemple, if "... niveau 8" output
A1
B1
A2
A3
I want to output
A2
B1
A2
A3
I use the property order but il is not working
thanks for you help
I don't know if this will work in a crosstab, but you could calculate a field to sort on.
Case [Category]
When 'Niveau 8' then
Case [Field]
When 'A2' then '1'
When 'B1' then '2'
When 'A2' then '3'
When 'A3' then '4'
Else [Field]
END
Else [Field]
END
Or something like that anyway...
C
Yess!!! Thanks it is working :)