SSRS Putting totals at the end of the report


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")

Enjoy!

No comments:

Note: only a member of this blog may post a comment.

Powered by Blogger.