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
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"