SSRS Example Wrapping a long thin tablix into two columns on the page

I have a report table with only a few columns but lots of rows. When printed it runs to several pages with a lot of white space (and wasted paper). I came up with a solution I’ll probably end up using again so decided to write it up and share.

Challenge

Wrap the tablix into two columns on the page. Records should appear to flow across the page (left to right). As opposed to down the first column then down the second column.

Solution

Introduce a hidden column in my Tablix containing a row number.

=RowNumber(“Tablix1”)

Copy and paste the Tablix then line the two up, side by side.

Access the Group properties for the default Details1 Group (containing the invisible row number). This is the first tablix on the left half of the page.

Either Filter the group (or set the visibility) by dividing (mod) the invisible row number by 2 and check for the remainder.

=IIF(ReportItems!Tab1Row.Value MOD 2 = 0 , True, False)

Access the Group for the Details2 Group in the second tablix on the right side of the page and filter the group (or set visibility) the same way. Note the switched True/False args.

=IIF(ReportItems!Tab2Row.Value MOD 2 = 0 , False, True)

Result

Pain Dashboard

My result is even numbered record items (row numbers) in the left column and odd in the right column. Report data appears to run left to right.

Advertisements

2 thoughts on “SSRS Example Wrapping a long thin tablix into two columns on the page

  1. Thanks! This is exactly what I was looking for. I cannot believe that SSRS cannot wrap long columns across the page to the next row for situations just like this. By the way, the graphics look great for your dashboard-like report/results. Did you design that yourself in SSRS or by some other means? I’d be interested in the details as I’ve got hundreds of servers to monitor and display basic server details–in the same fashion.

    • Thanks! Yes, this is an old report written in SSRS 2012.
      It involved bring in custom graphic icons for cell backgrounds and selecting them conditionally (like the arrows and male/female icons).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s