Export (0) Print
Expand All

Lesson 5: Adding a Subtotal

SQL Server 2005

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)
    
Subtotal expressionin table data region

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft