Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
You can add aggregate functions to the report. The following step adds a subtotal by sales person.
Click on the fourth cell in the last (Total Due) column and type the following expression.
=Sum(Fields!TotalDue.Value)
.gif "Subtotal expressionin table data region")
Next Steps
You have successfully added an expression that calculates a sum total of dollar sales for each sales person. Next, you will add formatting to improve the appearance of report data. See Lesson 6: Applying Formatting and Style.
See Also
Concepts
Tutorial: Adding Grouping, Sorting, and Formatting to a Basic Report
Other Resources
Expression Examples in Reporting Services
Using Report Functions in Expressions (Reporting Services)