Lesson 5: Adding a Subtotal

  • Article

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

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

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

Reference

Expression Examples in Reporting Services

Concepts

Using Report Functions in Expressions (Reporting Services)

Other Resources

Tutorial: Adding Grouping, Sorting, and Formatting to a Basic Report

Help and Information

Getting SQL Server 2008 Assistance