Posted by (JavaScript must be enabled to view this email address) on Fri 27 Mar 2009

To put a total at the end of the SSRS report, add a textbox to the DataSet Region and set the visibility property of the text-box to an expression - set the the expression to:

=iif(RowNumber("List1") = Count(Fields!.Value),true,false) 

Then a just set the expression on the text box to:

="Total between " & Parameters!.Value & " and " &_
Parameters!.Value + ": " & RowNumber("List1") 

and this is what it looks like rendered:

Enjoy!