title: SSRS tablix split report into two sets of columns
body: <p>I have a report that lists some basic data about a company for all (possibly) 52 weeks of the year. The report takes in parameters of year and UptoWeek. So for example i can put in 2013 and 31 and it will spit out all the values for year 2013 up to week 31. Right now it looks like: </p>
  
  <pre><code> Week  Dollars   PY Dollars   Change
   1     5         4            1
   2     20        25           -5
   ...
   52
  </code></pre>
  
  <p>I want it to split into two sets of columns at the halfway point, so the left side is 1-25 and the right side is 26-52 like so</p>
  
  <pre><code> Week  Dollars   PY Dollars   Change    Week  Dollars   PY Dollars   Change 
   1     5         4            1         26
   2     20        25           -5        27
   ...                                    ...
   25                                     52
  </code></pre>
  
  <p>Is this possible in tablix?</p>
  
  <p>The one thing I was thinking was to just copy the tablix next to itself and hide rows higher than 25 on the left, and lower than 26 on the right. I'm just not sure if that's the best way to handle this... </p>