For example, when filtering numbers, you’ll see Number Filters, for dates you'll see Date Filters, and for text you'll see Text Filters.
Dataset fields represent the data from a data connection.
The default scope is defined by the innermost row and column group to which the cell belongs.
Visual cues help you identify the groups for which a selected cell is a member. For an example of a default scope, the following figure has a parent row group that is based on date, a child row group that is based on order, and a details group.
A field can represent either numeric or non-numeric data.
Examples include sales amounts, total sales, customer names, database identifiers, URLs, images, spatial data, and e-mail addresses.
On the design surface, fields appear as expressions in report items such as text boxes, tables, and charts.
A report has three types of fields and displays them in the Report Data pane: dataset fields, dataset calculated fields, and built-in fields.
For more information, see Using Group Variables in Reporting Services 2008 for Custom Aggregation. However, you can change the Sum function to a different built-in function and perform a different aggregation for a scope.
You can also write your own expressions to calculate aggregate values for one scope relative to another scope.
Alternatively, you can specify a different aggregate function from the built-in functions or specify a different scope.
To customize an aggregate calculation, you can use group variables in combination with custom code.
Reapplying a filter To determine if a filter is applied, note the icon in the column heading: Do not mix data types For best results, do not mix data types, such as text and number, or number and date in the same column, because only one type of filter command is available for each column.