CalcOnChangedData: TriState;
CalcOnChangedData: Prognoz.Platform.Interop.ForeSystem.TriState;
The CalcOnChangedData property determines whether formula calculation is applied on changed data without saving them to analytical area.
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.
Executing the example requires that the repository contains an express report with the EXPRESS identifier.
Add links to the Express, Metabase, ForeSystem (for Fore.NET example) 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;
Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.Metabase;
Imports Prognoz.Platform.Interop.ForeSystem;
…
Public Shared Sub Main(Params: StartParams);
Var
MB: IMetabase;
Express: IEaxAnalyzer;
Area: IEaxDataArea;
Begin
// Get repository
MB := Params.Metabase;
// 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 = Prognoz.Platform.Interop.ForeSystem.TriState.tsOffOption)
Or (Area.CalcOnChangedData = Prognoz.Platform.Interop.ForeSystem.TriState.tsUndefined) Then
Area.CalcOnChangedData := Prognoz.Platform.Interop.ForeSystem.TriState.tsOnOption;
End If;
// Save report
(Express As IMetabaseObject).Save();
End Sub;
After executing the example, formula calculation on changed data without their saving will be enabled for analytical area slice of regular report.
See also: