12

Is it possible to pivote a table in reporting services 2008? If so, how? I'd like to pivote it 90 degrees.

Thanks

Leandro Bardelli
  • 10,561
  • 15
  • 79
  • 116
Johan
  • 753
  • 2
  • 11
  • 31
  • 2
    Rotate as in pivot it ?? Or rotate as in physically rotate the whole table ?? – general exception Jan 25 '12 at 15:22
  • 1
    As in having the Columns to the left and the rows lined out to the right where the columns usually are. – Johan Jan 25 '12 at 15:33
  • I edited this question in order to be specific for pivote and not rotating, I came here looking for how to rotate it, not pivote it. Good question and answer (voted it up) but not related. – Leandro Bardelli Aug 05 '19 at 15:05

1 Answers1

25

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 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.

Jim B
  • 420
  • 3
  • 10
Jamie F
  • 23,189
  • 5
  • 61
  • 77