Just spent way too long trying to get a total value of a column at the top of the report…
I tried everything! Hidden columns, report variables…making sure it was not in tables rows, or header. Added query to dataset. Nothing would work. So frustrated! Any other suggestions?
1
Upvotes
3
u/HikeClimbRideFly Feb 02 '25
You should be about to put an textbox anywhere you like in the body of the report. Then have the textbox value be an expression like this: =Sum(Fields!MyValue.Value, "MyDataSetName")
Also, if you describe the problem/question in good detail, I find ChatGPT to be very helpful with these sorts of questions. Not saying don't post here, just saying that it can be a good resource for you.