Search code examples
reporting-servicesformattingssrs-2008ssrs-tablix

SSRS wrap data vertically in a row, 1 to 5 in col A, 6 to 10 in col B?


Is this possible in SSRS?

For each row there are currently ten values, but due to the lengthy labels, I'm looking at creating a slightly different output format.

What I'd like to achieve is this:

______________________________________________________

    DATAROW 1    label 1 : <#1 highest value>  | label 6 : <#6 highest value>
                 label 2 : <#2 highest value>  | label 7 : <#7 highest value>
                  .                ...         |  .               ...
                 label 5 : <#5 highest value>  | label 10: <#10 highest value>
______________________________________________________

    DATAROW 2    label 1 : <#1 highest value>  | label 6 : <#6 highest value>
                 label 2 : <#2 highest value>  | label 7 : <#7 highest value>
                  .                ...         |  .               ...
                 label 5 : <#5 highest value>  | label 10: <#10 highest value>
______________________________________________________

    DATAROW n    ...

So half the values appear in the left hand side of the row and half on the right hand side - there will always be ten values

There are two row groups and one column group in the report as is, not sure if changing it to the above format would change this


Solution

  • Just create a column grouping based on

    =if (#value < 6,1,2)
    

    so 1-5 form the group "1" with 6-10 forming the group "2"