[转]Rotate a table in reporting services

转自:http://stackoverflow.com/questions/9002796/rotate-a-table-in-reporting-services

 

12down voteaccepted

In SSRS 2008, there isn't much difference between rows and columns.* A Table is an instance of a "Tablix" which has the detail group on the rows. You can have your table either repeat rows or columns based on the groupings and where the details group is set.

You can create a horizontally expanding table by:

  1. First create a Tablix by dragging the Matrix Report Item onto the design surface. The Tablix will have a RowGroup and a ColumnGroup by default.
  2. Delete the Row Group by right clicking on it and selecting "Delete Group" In the Delete Group prompt, delete both just the group. (Not related rows and columns; you'll probably want these as left label for your rows.)
  3. Add the Details group as a Child Group of the Column Group. Do this by Right clicking on the Column Group and "Add Group->Child Group..." Select Show Details Data.

The resulting tablix should look something like this:

Horizontally expanding Tablix

You can now add columns, rows, groups, etc.

*One minor difference that comes to mind is that you can merge cells horizontally, but not vertically.

posted @ 2014-08-29 17:44  Reinhard_Hsu  阅读(233)  评论(0编辑  收藏  举报