IPivot.UseDataCache

Syntax

UseDataCache: Boolean;

Description

The UseDataCache property determines whether data cache is used while working with table.

Comments

Available values:

True. Data caching is used. All the data obtained from a source according to the given selection, falls into cache. Data is obtained from cache on selection change. Missing data is obtained from data source and also cached.
False. Default value. Data caching is not used.

NOTE. Data from server aggregation is not cached.

Example

Executing the example requires a form, two buttons named Button1 and Button2, the TabSheetBox component named TabSheetBox1, the UiErAnalyzer component named UiErAnalyzer1 and the ErAnalyzerDimPanel component named ErAnalyzerDimPanel1. An express report is connected to the UiErAnalyzer1 component.

Class TESTForm: Form
    UiErAnalyzer1: UiErAnalyzer;
    TabSheetBox1: TabSheetBox;
    ErAnalyzerDimPanel1: ErAnalyzerDimPanel;
    Button1: Button;
    Button2: Button;
    Pivot: IPivot;

    Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
    Begin
        Pivot := (UiErAnalyzer1.Instance As IEaxAnalyzer).Pivot;
        Pivot.UseDataCache := True;
    End Sub Button1OnClick;

    Sub Button2OnClick(Sender: Object; Args: IMouseEventArgs);
    Begin
        If Pivot <> Null Then
            Pivot.FlushDataCache;
        End If;
    End Sub Button2OnClick;

End Class TESTForm;

After starting the form, clicking the Button1 button activates data caching for the express report table. Clicking the Button2 button activates clearing of available cached data.