Does SQL Server 2005 Reporting Services support horizontal tables which have fixed rows and dynamic columns?
Note: This Q&A is only for SQL Server 2005 Reporting Services. By default, there is no native “horizontal table” report item. We can use Matrix to simulate simple horizontal tables: 1. Add a matrix to your report. 2. Add static rows to the matrix: Right-click in the Data cell and select “Add Row”. Repeat for the number of fixed rows you want. 3. Drag fields into the Data cells: You’ll notice that the design tool automatically wraps your field reference in the “First” aggregate (e.g. =First(Fields!City.Value)). Since you’re doing this in the context of a matrix, the design tool is ensuring that the expression is meaningful even in the context of a subtotal or if the matrix is showing aggregated data rather than detail data. Note: Please do NOT remove the aggregate expression. 4. Add a column grouping: 1) Right-click on the column header and select “Edit Group”. 2) Enter this for the group expression: =RowNumber(Nothing). This will cause the matrix to give you one column per row of data.
