IPivotFilterSource.Enable

Syntax

Enable: Boolean;

Description

The Enable property determines whether filter can be applied.

Comments

Available values:

True. Filter is applied. Default value.
False. Application of filter is disabled.

Example

Executing the example requires that the repository contains an express report with the EXPRESS identifier with connected filter. Filter connection is described in the example for the IPivotFilterSource.Matrix property.

Add links to the Express, Metabase, Pivot system assemblies.

Sub UserProc;
Var
    Mb: IMetabase;
    Eax: IEaxAnalyzer;
    Pvt: IPivot;
    Filter: IPivotFilterSettings;
    FltrSources: IPivotFilterSources;
    FltrSource: IPivotFilterSource;
Begin
    // Get repository
    Mb := MetabaseClass.Active;
    // Get express report
    Eax := MB.ItemById("EXPRESS").Edit As IEaxAnalyzer;
    // Get report data table display options
    Pvt := Eax.Pivot;
    // Determine filtering parameters
    Filter := Pvt.Filter As IPivotFilterSettings;
    // Set external filter use
    FltrSources := Filter.FilterSources;
    // Get connected filter
    FltrSource := FltrSources.Item(0);
    // Disable filter use
    FltrSource.Enable := False;
    // Save report
    (Eax As IMetabaseObject).Save;
End Sub UserProc;

After executing the example, filter use is enabled in the report.