title: SSRS: Need Count of Actual Rows in Report
body: <p>I have a Text Box in the Footer section of my report with the following expression:</p>
  
  <pre><code>= " Total Loans: " &amp; CountRows("MyDatasetName") &amp; "."
  </code></pre>
  
  <p>This returns a value that is not the exact number of rows displayed on the report [I manually counted]. There are 30 rows in the report - and the Total Loans reported by my expression is 34.</p>
  
  <p>What I would REALLY like to do is get a count of the rows that are displayed in the report.</p>
  
  <p>If I run the SQL for the Dataset in SSMS - I get 34 rows.</p>
  
  <p>??</p>
  
  <p>Thanks in advance!!</p>