SSRS tablix breaks a report into two sets of columns

Question

I have a report that lists some basic company information for everyone (maybe) 52 weeks a year. The report contains the parameters for the year and UptoWeek. So, for example, I can set 2013 and 31, and he will spit out all the values ​​for 2013 up to 31 weeks. Now it looks like this:

Week Dollars PY Dollars Change 1 5 4 1 2 20 25 -5 ... 52 

I want it to be divided into two sets of columns at half point, so the left side is 1-25 and the right side is 26-52, so

  Week Dollars PY Dollars Change Week Dollars PY Dollars Change 1 5 4 1 26 2 20 25 -5 27 ... ... 25 52 

Is this possible in tablix?

The only thing I was thinking about was just copying the tablix next to me and hide the lines above 25 on the left and below 26 on the right. I'm just not sure if this is the best way to handle this ...

Answer 1

You can customize a group of columns based on an expression like:

 =IIf(Fields!Week.Value <= 26, 1, 0) 

Note that this value is 26, since 26 should really be on the left side. I think.

Your string group expression should look something like this:

 =(Fields!Week.Value - 1) Mod 26 

So to speak, I have such data:

(notch)

And a label like this, grouped as above:

With the above grouping, this works for me:

(notch)

This will allow you to divide your data into two groups depending on the week and, as such, will meet your requirements. Since you are only interested in two groups and have a finished line number in Week , you can keep the expression simple.

Tables side by side are likely to be good too, but SSRS, as you know, is temperamental with neighboring objects. Using grouping as described above saves this as a single element at the designer level.