IEaxDataArea.CalcOnChangedData

Syntax

CalcOnChangedData: TriState;

Description

The CalcOnChangedData property determines whether formula calculation is applied on changed data without saving them to analytical area.

Comments

Available values:

TriState.OnOption. Formulas are calculated on changed data.
TriState.OffOption. Formulas are not calculated on changed data.
TriState.Undefined. Default value. Formulas are not calculated on changed data.

Example

Executing the example requires that the repository contains an express report with the EXPRESS identifier.

Add links to the Express and Metabase system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Area: IEaxDataArea;
Begin
     // Get repository
    MB := MetabaseClass.Active;
    // Get express report
    Express := MB.ItemById("EXPRESS").Edit As IEaxAnalyzer;
    // Get analytical area of express report
    Area := Express.DataArea;
    // Set formula calculation on changed data
    If ( Area.CalcOnChangedData = TriState.OffOption) Or (Area.CalcOnChangedData = TriState.Undefined) Then
        Area.CalcOnChangedData := TriState.OnOption;
    End If;
    // Save report
    (Express As IMetabaseObject).Save;
End Sub UserProc;

After executing the example, formula calculation on changed data without their saving will be enabled for analytical area slice of regular report.