Rotate table?

Hi,

I'm searching how I can 'rotate' a table in Reporting Services. Now I have drawn a table like this:

- header
- detail --
--footer--

This will result in vertical grown when there are more details found. I want that the table grows horizontally, like this:

| | |
H D F
E E O
A T O
D A T
E I E
R L R
| | |

(Pffw, talking about ASCII art :) )

How would I do this? Thanks for any clarification.

You can try using a matrix instead of table. The header would be the static row header, the detail would be the column groupings (you'll need to group on a field that's unique across different rows if you want each data row to show up as a column), and you can put the footer in the subtotal column (you may need to use the InScope() function in order to display different contents than the details).