title: SSRS in Visual Studio: Matrix grouping takes only the first row
body: <p>Here's the situation. I'm doing a SSRS report in VisualStudio 2010. For some reasons, I can't do it from SQL Server and I can't change the stored procedure I use to get my data either. I receive data in the following format:</p>
  
  <pre><code>2013-01-28  4.0         NCI       
  2013-01-28  4.0         VAC       
  2013-01-30  4.0         NCE       
  2013-01-27  3.0         SF        
  2013-01-27  5.0         CSST      
  2013-01-29  1.0         SF        
  2013-01-29  2.0         NCE   
  </code></pre>
  
  <p>I want to make a matrix and group it by date to get something like this:</p>
  
  <pre><code>Date        Amount      Code
  2013-01-27  
              3.0         SF        
              5.0         CSST   
  2013-01-28  
              4.0         NCI       
              4.0         VAC  
  2013-01-29  
              1.0         SF        
              2.0         NCE      
  2013-01-30  
              4.0         NCE       
  </code></pre>
  
  <p>This looks like a simple task but all the tutorials I tried ended up giving me only the first row of each date. I'm quite confused as I have no idea what I could be doing wrong.</p>