title: SSRS, Limit Fixed number of Columns in Matrix within a Tablix - issue in sorting matrix data
body: <p>I am converting a crystal report to ssrs report, i am trying to implement "Format With Multiple Columns" feature of crystal report to ssrs.</p>
  
  <p>I have a Main tablix that has two Two Groups </p>
  
  <ul>
  <li>1st Group - PolicyType </li>
  <li>2nd Group - WeekNumber</li>
  </ul>
  
  <p>Under Week Number group, i have inserted a rectangle and a matrix within it. The matrix will show the policy number generated in every week. The matrix should only contain 6 columns and the grouping for matrix is as below</p>
  
  <ul>
  <li>Row Grouping : Ceiling(RowNumber("WeekNumber") / 6)</li>
  <li>Column Grouping : Ceiling(RowNumber("WeekNumber") MOD 6)</li>
  </ul>
  
  <p>I need a output like below</p>
  
  <p><strong>InsuranceType1</strong><br/>
  <strong><em>Week 1</em></strong><br/>
  Policy Number<br/>
  1001 1002 1003 1004 1005 1006 <br>
  1007 1008 1009 1010 <br/>
  <strong><em>Week 2</em></strong><br/>
  Policy Number<br/>
  2001 2002 2003 2004 2005 2006 <br>
  2007 2008 2009 2010 <br/></p>
  
  <p><br/> I am able to get a similar output but the sorting within the matrix is not working, ie., i get the following result<br/>
  <strong>InsuranceType1</strong><br/>
  <strong><em>Week 1</em></strong><br/>
  Policy Number<br/>
  1002 1003 1001 1004 1007 1006 <br>
  1005 1008 1009 1010 <br/>
  <strong><em>Week 2</em></strong><br/>
  Policy Number<br/>
  2008 2009 2003 2004 2005 2006 <br>
  2007 2001 2002 2010 <br/></p>
  
  <p><br/> i have not used any sorting on the Matrix, nor in the group of matrix the only sorting is on the main tablix groups PolicyType and WeekNumber and both are in ascending order. </p>
  
  <p>What i have tried is:</p>
  
  <ol>
  <li>Sort Matrix using PolicyNumber, but that will only output first row and first column (very strange!!!). </li>
  <li>Add an additional sort of PolicyNumber in Group WeekNumber (did not work either)</li>
  </ol>
  
  <p><br/> i have no option of modifying the stored procedure to return the row number back to the report as the client is strict on SP modification as they want to get this report backward compatible. </p>
  
  <p>Please help!!</p>