IPivotFilterSettings.UseTransformationFilter

Fore Syntax

UseTransformationFilter: Boolean;

Fore.NET 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. 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.

Fore and Fore.NET Examples

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