title: ReportViewer pagination based on Grouping on Rownumber expression
body: <p><img src="https://i.stack.imgur.com/SydrR.png" alt="enter image description here">I have created a Group on rows based on the following expression in my Report:</p>
  
  <pre><code>=Int((RowNumber(Nothing)-1)/5)
  </code></pre>
  
  <p>What is happening on the report is, I am getting only the first record of every group (and not all records in that group). Also on the Toolbar Pager, when the report initially comes, it shows: <code>1 of 2 ?</code> and then when I click on "Next" button, it shows <code>2 of 3 ?</code> and so on keeps on increasing like this pattern. </p>
  
  <p>I am very new to reporting, and I don't know from where this Question Mark is coming and why its not showing all the records in the group. </p>
  
  <p>Thanks for any help.</p>
  
  <blockquote>
    <p>UPDATE [1 Day after posting] :-</p>
  </blockquote>
  
  <p>I have figured it out now, why its happening, the problem is: There are RowGroups attached to the Report that are not getting deleted. When I click on "Advanced" in the bottom pane of Visual Studio, it shows: <code>Column Groups</code> and <code>Row Groups</code>. In a fresh new report, when I drag a <code>Table</code>, the <code>Row Grops</code> contain less number of Items then are here. I have tried deleting the Group by opening its XML View, but then Visual Studio crashed.</p>
  
  <p>Any body knows how to delete the <code>Group</code> from <code>RowGroups</code> ? This might solve the problem.</p>