title: SSRS group not showing all records
body: <p>I'm having an issue getting the report to show all the records within the grouping.</p>
  
  <p><img src="https://s6.postimg.org/dcfij1tn5/grouping_error_preview.png" alt="Result Set screenshot" title="Result Set"></p>
  
  <p>The grouping totals are correct, however it's not showing all the records.</p>
  
  <p><img src="https://s6.postimg.org/s9nzk26vl/sql_result_set.png" alt=""></p>