Link to home
Start Free TrialLog in
Avatar of DaneBigham
DaneBighamFlag for United States of America

asked on

Sum textbox values in Reporting Services

I'm new to Microsoft's SQL Reporting Services, using Visual Studio to create reports.  Due to an unusual gathering of data, I have a need to create a Grand Total level textbox that sums the values of another textbox within a report (*NOT* values from a dataset field).  Either I don't know the syntax, or it doesn't seem to be possible.  I would want something like =Sum(textboxname), but that doesn't seem to be an option.  An alternative would be to create a variable that adds up textboxname each time it's displayed on the report, than display the variable in the Grand Total, but I don't see how to do that either.

Any help would be greatly appreciated.
ASKER CERTIFIED SOLUTION
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial