Sum of expressions in SSRS

Daniel Trocker
Daniel Trocker used Ask the Experts™
on
Hello,

which is the easiest way to sum expressions in SSRS?
I want to group my rows, but only the fields within the dataset sum up.

Thanks,
Daniel
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Developer
Top Expert 2014
Commented:
The easiest way is to include the calculations in your initial query instead of torturing the report builder into doing it for you. Of course, that isn't always feasible. If you give us a sample of your query or report we can help you more directly.
Daniel TrockerSales Operations Manager

Author

Commented:
Hi Russell,

do you mean it is easiest doing it directly when I write the query from "datasource" to "dataset"? I found a solution of doing it in the report builder by putting the "sum"-funtction in front of the expression.

BR
Daniel
Russell FoxDatabase Developer
Top Expert 2014

Commented:
Nope, you're totally right, I just thought you were doing something more complicated, like sums of sums.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial