SSRS Display dataset results are displayed horizontally

Question

I have the following data in my dataset

| Person | Bonus | John | 15,000 Mary | 20,000 Steve | 5,000 Betty | 10,000 

I want my table to match so that the rows are displayed horizontally, not vertically

 John 15,0000 Mary 20,000 Steve 5,0000 Betty 10,000 

How to do this with SSRS 2008?

Answer 1

To make rows appear horizontally rather than vertically, you want to add a group of columns to the person’s name. Right-click on the Detail cell in your table, click Add Group and select Column Group - Parent Group and Group By Person . This will display Person as a column that will expand horizontally, sort of like a matrix.

However, the layout you show is more like using multiple column layouts. To use multiple columns, click anywhere in the empty report area and go to the "Properties" window (do not right-click and select "Properties" because the "Columns" property does not appear in the pop-up dialog in SSRS 2008), Columns and enter 2 for Columns , then place your report as usual, making sure that several columns plus the distance between the columns do not exceed the width of your page.

Note that not all renderers support multiple columns, including Report Designer and standard HTML web rendering, so they will display only one column independently - Print and PDF support multiple columns. However, there is a hack that you can use to fake multiple columns using two tables .