Ideally that is what I would like to do. But I need to show additional information
at the row group level. For example if I am grouping by field , then I also need to show
name, description and a small colored box for a color code for that group.
And then I need to show the cross tab information for that group.I need a table something like what is shown below:
X Y X
A.Name A.Description A.ColorCodeBox Var1 0 1 2
Var2 2 3 4
Var3 2 4 4
B.Name B.Description B.ColorCodeBox Var1 0 1 2
Var2 2 3 4
Var3 2 4 4
Where the numbers are some values, X,Y,Z are the column headings and A & B represent different values in that group.
Since I could not find any solution for that, I decided to display the additional information on top of the crosstab table and insert a crosstab in each group.
Please let me know if you have a solution for either one of the two.
Thanks.