ShowFormulaDialog Command

Purpose

Opens the functions wizard of a regular report.

Parameters of Use

Command parameters are passed in the Data property. Executing the command requires to specify an array of the Variant type in this property, the elements of this array contain the following values:

Value type	Description
Element 1: IPrxReport	The regular report, for which a function is created.
Element 2: String	The function, on which the functions wizard pointer is focused. The name of function or an empty string if function is unknown must be defined as a value.

Application Features

The command is used only for regular reports. Executing the command shows logical True if the OK button is clicked, and logical False if the Cancel button is clicked. If the function was created, and the OK button is clicked in the wizard, this function can be obtained by getting the value of the Data property and casting it to the array. The value of the formula will be in the element 2 of array.

Example

Executing the example requires a form with the Button1 button, the ReportBox component and the UiReport component named UiReport1, which is used as a data source for the ReportBox component. The UiReport1 component is connected to a regular report.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    Target: IUiCommandTarget;
    Context: IUiCommandExecutionContext;
    Data: Array;
Begin
    Target := WinApplication.Instance.GetPluginTarget("Report");
    Context := Target.CreateExecutionContext;
    Data := New Variant[2];
    Data[0] := UiReport1.Instance;
    Data[1] := "Abs";
    Context.Data := Data;
    If (Target.Execute("ShowFormulaDialog", Context) As Boolean) Then
        Debug.WriteLine((Context.Data As Array)[1]);
    Else
        Debug.WriteLine("Creating of function is cancelled.");
    End If;
End Sub Button1OnClick;

Clicking the button opens the functions wizard. The pointer is focused on the Abs function. The full text of the function is displayed in the development environment console after the function is created, and the OK button is clicked.