Express > Express Assembly Interfaces > IEaxDataAreaPivotSlice > IEaxDataAreaPivotSlice.CalcOnChangedData
CalcOnChangedData: Boolean;
The CalcOnChangedData property determines whether formula calculation is applied to changed data without saving it for analytical area slice.
Available values:
True. Formulas are calculated on changed data.
False. Formulas are not calculated on changed data.
Executing the example requires that the repository contains a regular report with the REPORT identifier.
Add links to the Express, Metabase and Report system assemblies.
Sub UserProc;
Var
MB: IMetabase;
Report: IPrxReport;
DataArea: IEaxDataArea;
RepGrid: IEaxGrid;
PivSlice: IEaxDataAreaPivotSlice;
Begin
// Get repository
MB := MetabaseClass.Active;
// Get analytical data area of regular report
Report := MB.ItemById("REPORT").Edit As IPrxReport;
DataArea := Report.DataArea;
// Get table data view
RepGrid := DataArea.Views.Item(0) As IEaxGrid;
// Get base for building analytical data area slice
PivSlice := DataArea.Slices.Item(0) As IEaxDataAreaPivotSlice;
// Set calculation of formulas on changed data
If (PivSlice.CalcOnChangedData = False) Then
PivSlice.CalcOnChangedData := True;
End If;
// Save report
(Report As IMetabaseObject).Save;
End Sub UserProc;
After executing the example, formula calculation on changed data without their saving is enabled for analytical area slice of regular report.
See also:
