how to arrange data horizontally in SQL Server 2005 report designer

I am wondering whether anyone knows, in SQL Server 2005 reporting service, how to arrange data (retrieved from a table field) horizontally (from left to right) instead of vertically (from top to bottom).

It is natural to arrange data vertically. However, it is not easy to arrange data horizontally. I tried using the multi-column feature in the reporting service to achieve the effect. It does not work. I also considered writing SQL code to transpose data (rows to columns, columns to rows). It does not help either.

Does anyone know how to achieve the effect? Is there a work-around?

Any idea, tip, or suggestion is greatly appreciated.

Thanks.

Use a matrix report on top of the data.|||

Besides using a matrix, you could also look into the "horizontal table" approach describes on Chris Hays' blog: http://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspx

-- Robert