IPivotFilterSettings.UseTransformationFilter

Syntax

UseTransformationFilter: Boolean;

Description

The UseTransformationFilter property determines whether data filtering by formula is used.

Comments

Available values:

True. Data filtering by formula is used. Filtering parameters are set in the IEaxDataAreaSlice.FilterTransformations collection.
False. Default value. Data filtering by formula is not used.

To use the property, it is required that the IPivotFilterSettings.Enabled property is set to True.

If a formula contains parameter, the ":" character is placed before the parameter. For example, a formula looks as follows: AttributeId >= :Parameter, where:

AttributeId. Dictionary attribute identifier.
:ParametrId. Report parameter identifier.

Example

The example of use is given in description of the IEaxDataAreaSlice.FilterTransformations property.