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
