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.
Suggestion at this link 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.
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.
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 :(
Also please consider that moving filter criteria in stored procedure is not an option for me.
Thanks, Ravi