title: Count rows of a filtered tablix in SSRS
body: <p>I want to show row count of my filtered tablix in a text-box inside my SSRS report header. I googled quite a bit but nothing helped. </p>
  
  <p>Suggestion at <a href="http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/4f8789cf-010e-4ae3-8368-10a4c177574f" rel="noreferrer">this link</a> gives me count but that is restricted to count of rows coming on current page. Even if my result has 2 pages, I get count of rows in first page only. </p>
  
  <p>I also tried by adding a new column for row number and then show it's value in header's text-box but the problem remain same as above.</p>
  
  <p>I tried using global shared variables in report(I am using custom code for filter), this helped upto an extent but they keep on accumulating value every-time I click view report button :(</p>
  
  <p>Also please consider that moving filter criteria in stored procedure is not an option for me.</p>
  
  <p>Thanks,
  Ravi</p>