O'Reilly logo

Microsoft® SQL Server® 2008 Reporting Services Step by Step by Stacia Misner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Aggregate Functions

You use aggregate functions primarily to summarize many records of numerical data, such as giving a total or average value. You can also use aggregate functions to get the first or last string value in a group of records.

To work successfully with aggregate functions, you must first understand how the location of an expression in the report affects when it is evaluated. An expression in the report body has access to the dataset and therefore can reference an object directly in the Fields collection. However, an expression in the page header or page footer is evaluated after the report body is processed when the dataset is no longer available. Although you can no longer use the Fields collection, you can access the results ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required