Rotate table in a report from crosstab query

[notfound]

Hello all,

I would like to base a report on a crosstab query.

The report wizard produces it in this format:

                     Venue1  Venue2 ... 
Category1  Subcategory1      1       3
Category1  Subcategory2      2       2
Category2  Subcategory1      1       2
Category2  Subcategory2      6       3 
Category3  Subcategory1      4       8
Category3  Subcategory2      3       2

But I would like this format:

             Cat1Subcat1  Cat1Subcat2  Cat2Subcat1 Cat2Subcat2 ..
Venue1        1              2            1           6
Venue2        3              2            2           3
...

So how do I rotate the report? Or do I need to rotate the crosstab query somehow?

Thanks for your time,
nf

 

[DCrake]

I think everyone here would have liked to do just that at some point, alas I have jet to find an "easy" way to do this.

David