Pivot a table in reporting services?

by

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.

More Related Contents:

  1. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports are blank in Safari and Chrome
  2. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports in Safari/Chrome but works fine in Firefox/Internet Explorer 8… why?
  3. SSRS Conditional Formatting Switch or IIF
  4. Access Page number in report body In SSRS
  5. How to get rid of blank pages in PDF exported from SSRS
  6. SSRS multi-value parameter using a stored procedure
  7. Compare SQL Server Reporting Services to Crystal Reports [closed]
  8. Does the iif function compute both paths in SSRS or is it short-circuited?
  9. SSRS Expression Divide by Zero Error
  10. Reporting Services export to Excel with Multiple Worksheets
  11. Changes to parameter not showing on Report Server after deployment
  12. When to use RDLC over RDL reports?
  13. SSRS 2005 Set SimplePageHeaders on the report instead of the server?
  14. divide by zero/null workaround in SSRS 2008 report
  15. Need help in calculation using two Datasets using Expression SSRS
  16. SSRS – How to build a simple multi-column report?
  17. SSRS – How to continue data to next column?
  18. SSRS distinct lookupset function
  19. How do I format date and time on ssrs report?
  20. Optional multi-valued parameters in SSRS
  21. Passing Credentials to Sql Report Server 2008
  22. How to combine aggregates within a group with aggregates across groups within SSRS
  23. Programmatically Export SSRS report from sharepoint using ReportService2010.asmx
  24. The permissions granted to user ‘ are insufficient for performing this operation. (rsAccessDenied)”}
  25. Passing parameter via url to sql server reporting service
  26. Add alternating row color to SQL Server Reporting services report
  27. Sql PIVOT and string concatenation aggregate
  28. Tablix: Repeat header rows on each page not working – Report Builder 3.0
  29. SQL Reporting Services – Print Button not shown in Mozilla
  30. Viewing SSRS Reports in an ASP.net MVC Site

Leave a Comment