SSRS – How to build a simple multi-column report?

by

For Horizontal layout of labels…

One choice is to use the columns property on the report or body elements.
This doesn’t always display correctly On reportviewer. I’ve noticed that even if it displays correctly on your IDE and when you export to PDF. In the report viewer it will display only one column. Also it snakes the labels top to bottom then left to right.

One choice is to use a matrix and group on every 3 rows (if you want 3 columns).

This one is a little complicated.

My solution of choice is to put 3 vertical lists on the page. put the same label in each list. Return the row number in your dataset. Then just filter each list on modulo 3

For example

Result set

RIndex Fname
1 abe
2 burt
3 fred
4 george

Filter expressions

list 1 -> =Fields!RIndex.Value mod 3 = =1
list 2 -> =Fields!RIndex.Value mod 3 = =2
list 3 -> =Fields!RIndex.Value mod 3 = =0

Result

Abe Burt Fred 
George

More Related Contents:

  1. SSRS multi-value parameter using a stored procedure
  2. Compare SQL Server Reporting Services to Crystal Reports [closed]
  3. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports are blank in Safari and Chrome
  4. Does the iif function compute both paths in SSRS or is it short-circuited?
  5. SSRS Expression Divide by Zero Error
  6. Reporting Services export to Excel with Multiple Worksheets
  7. When to use RDLC over RDL reports?
  8. SSRS 2005 Set SimplePageHeaders on the report instead of the server?
  9. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports in Safari/Chrome but works fine in Firefox/Internet Explorer 8… why?
  10. SSRS – How to continue data to next column?
  11. SSRS distinct lookupset function
  12. SSRS Conditional Formatting Switch or IIF
  13. How to combine aggregates within a group with aggregates across groups within SSRS
  14. Pivot a table in reporting services?
  15. Access Page number in report body In SSRS
  16. The permissions granted to user ‘ are insufficient for performing this operation. (rsAccessDenied)”}
  17. Passing multiple values for a single parameter in Reporting Services
  18. How to get rid of blank pages in PDF exported from SSRS
  19. Passing parameter via url to sql server reporting service
  20. Add alternating row color to SQL Server Reporting services report
  21. Fast query runs slow in SSRS
  22. Why does the 2nd T-SQL query run much faster than the first when called by Reporting Services 2005 in a web-app
  23. SSRS report definition is newer than Server
  24. Passing a parameter via URL to SQL Server Reporting Services
  25. Need help in calculation using two Datasets using Expression SSRS
  26. how to remove time from datetime
  27. How do I format date and time on ssrs report?
  28. How to get total of top 10 sales in SSRS 2012
  29. Viewing SSRS Reports in an ASP.net MVC Site
  30. Programmatically Export SSRS report from sharepoint using ReportService2010.asmx

Leave a Comment