Page 9188 Generic Chart Customization

Base Application, System.Visualization

src/Layers/W1/BaseApp/System/GenericChart/GenericChartCustomization.Page.al967 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.Visualization;using System;using System.IO;using System.Reflection;using System.Utilities;page 9188 "Generic Chart Customization"{    Caption = 'Generic Chart Customization';    DeleteAllowed = false;    InsertAllowed = false;    PageType = Card;    ShowFilter = false;    SourceTable = Chart;    layout    {        area(content)        {            group("Measures (Y-Axis)")            {                Caption = 'Measures (Y-Axis)';                //The GridLayout property is only supported on controls of type Grid                //GridLayout = Rows;                grid(Control25)                {                    GridLayout = Rows;                    ShowCaption = false;                    group("Required Measure")                    {                        Caption = 'Required Measure';                        field("DataColumn[1]"; DataColumn[1])                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Data Column';                            ColumnSpan = 1;                            Editable = DataColumn1Enabled;                            Enabled = DataColumn1Enabled;                            RowSpan = 1;                            ToolTip = 'Specifies the field or query column that the y-axis is based on. The list of values that appears when you choose Data Column field is filtered by the ID of the data source that you select on the Data Source FastTab.';                            trigger OnLookup(var Text: Text): Boolean                            begin                                GenericChartMgt.RetrieveFieldColumn(TempGenericChartSetup, DummyInt, DataColumn[1], DummyCaption, 2, false);                                ValidateDataColumn(1);                            end;                            trigger OnValidate()                            begin                                ValidateDataColumn(1);                            end;                        }                        field("Aggregation[1]"; Aggregation[1])                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Aggregation';                            ColumnSpan = 1;                            OptionCaption = 'None,Count,Sum,Min,Max,Avg';                            RowSpan = 1;                            ToolTip = 'Specifies how data on the y-axis is aggregated, such as by the sum or by the maximum values.';                            trigger OnValidate()                            begin                                CheckAggregation(1);                                UpdateChartDefinition();                            end;                        }                        field(ChartType; ChartType)                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Graph Type';                            OptionCaption = 'Column,Point,Line,ColumnStacked,ColumnStacked100,Area,AreaStacked,AreaStacked100,StepLine,Pie,Doughnut,Range,Radar,Funnel';                            ToolTip = 'Specifies how data is shown graphically in the chart, such as column, line, or pie.';                            trigger OnValidate()                            begin                                UpdateChartDefinition();                                EnableControls();                            end;                        }                        field("MeasureCaption[1]"; MeasureCaption[1])                        {                            ApplicationArea = Basic, Suite;                            AssistEdit = false;                            Caption = 'Caption';                            Editable = DataColumn1Enabled;                            Enabled = DataColumn1Enabled;                            ToolTip = 'Specifies the caption that is shown next to the y-axis to describe the selected measure. You can enter captions in different languages by creating several lines with different language codes.';                            trigger OnAssistEdit()                            begin                                MeasureCaption[1] := GenericChartMgt.TextMLAssistEdit(TempGenericChartCaptionsBuf, GenericChartMgt.RequiredMeasureCode());                                UpdateChartDefinition();                            end;                            trigger OnValidate()                            begin                                TempGenericChartCaptionsBuf.SetCaption(GenericChartMgt.RequiredMeasureCode(), GenericChartMgt.GetUserLanguage(), MeasureCaption[1]);                                UpdateChartDefinition();                            end;                        }                    }                    group("Optional Measure 1")                    {                        Caption = 'Optional Measure';                        field("DataColumn[2]"; DataColumn[2])                        {                            ApplicationArea = Basic, Suite;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled and DataColumn2Enabled;                            ShowCaption = false;                            trigger OnLookup(var Text: Text): Boolean                            begin                                GenericChartMgt.RetrieveFieldColumn(TempGenericChartSetup, DummyInt, DataColumn[2], DummyCaption, 2, false);                                ValidateDataColumn(2);                            end;                            trigger OnValidate()                            begin                                ValidateDataColumn(2);                            end;                        }                        field("Aggregation[2]"; Aggregation[2])                        {                            ApplicationArea = Basic, Suite;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled;                            OptionCaption = 'None,Count,Sum,Min,Max,Avg';                            ShowCaption = false;                            trigger OnValidate()                            begin                                CheckAggregation(2);                                UpdateChartDefinition();                            end;                        }                        field("ChartTypeReduced[2]"; ChartTypeReduced[2])                        {                            ApplicationArea = Basic, Suite;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled;                            OptionCaption = 'Column,Point,Line,ColumnStacked,ColumnStacked100,Area,AreaStacked,AreaStacked100,StepLine,,,Range';                            ShowCaption = false;                            trigger OnValidate()                            begin                                UpdateChartDefinition();                                EnableControls();                            end;                        }                        field("MeasureCaption[2]"; MeasureCaption[2])                        {                            ApplicationArea = Basic, Suite;                            AssistEdit = false;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled and DataColumn2Enabled;                            ShowCaption = false;                            trigger OnAssistEdit()                            begin                                MeasureCaption[2] := GenericChartMgt.TextMLAssistEdit(TempGenericChartCaptionsBuf, GenericChartMgt.OptionalMeasure1Code());                                UpdateChartDefinition();                            end;                            trigger OnValidate()                            begin                                TempGenericChartCaptionsBuf.SetCaption(GenericChartMgt.OptionalMeasure1Code(), GenericChartMgt.GetUserLanguage(), MeasureCaption[2]);                                UpdateChartDefinition();                            end;                        }                    }                    group("Optional Measure 2")                    {                        Caption = 'Optional Measure';                        field("DataColumn[3]"; DataColumn[3])                        {                            ApplicationArea = Basic, Suite;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled and DataColumn3Enabled;                            ShowCaption = false;                            trigger OnLookup(var Text: Text): Boolean                            begin                                GenericChartMgt.RetrieveFieldColumn(TempGenericChartSetup, DummyInt, DataColumn[3], DummyCaption, 2, false);                                ValidateDataColumn(3);                            end;                            trigger OnValidate()                            begin                                ValidateDataColumn(3);                            end;                        }                        field("Aggregation[3]"; Aggregation[3])                        {                            ApplicationArea = Basic, Suite;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled;                            OptionCaption = 'None,Count,Sum,Min,Max,Avg';                            ShowCaption = false;                            trigger OnValidate()                            begin                                CheckAggregation(3);                                UpdateChartDefinition();                            end;                        }                        field("ChartTypeReduced[3]"; ChartTypeReduced[3])                        {                            ApplicationArea = Basic, Suite;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled;                            OptionCaption = 'Column,Point,Line,ColumnStacked,ColumnStacked100,Area,AreaStacked,AreaStacked100,StepLine,,,Range';                            ShowCaption = false;                            trigger OnValidate()                            begin                                UpdateChartDefinition();                                EnableControls();                            end;                        }                        field("MeasureCaption[3]"; MeasureCaption[3])                        {                            ApplicationArea = Basic, Suite;                            AssistEdit = false;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled and DataColumn3Enabled;                            ShowCaption = false;                            trigger OnAssistEdit()                            begin                                MeasureCaption[3] := GenericChartMgt.TextMLAssistEdit(TempGenericChartCaptionsBuf, GenericChartMgt.OptionalMeasure2Code());                                UpdateChartDefinition();                            end;                            trigger OnValidate()                            begin                                TempGenericChartCaptionsBuf.SetCaption(GenericChartMgt.OptionalMeasure2Code(), GenericChartMgt.GetUserLanguage(), MeasureCaption[3]);                                UpdateChartDefinition();                            end;                        }                    }                    group("Optional Measure 3")                    {                        Caption = 'Optional Measure';                        field("DataColumn[4]"; DataColumn[4])                        {                            ApplicationArea = Basic, Suite;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled and DataColumn4Enabled;                            ShowCaption = false;                            trigger OnLookup(var Text: Text): Boolean                            begin                                GenericChartMgt.RetrieveFieldColumn(TempGenericChartSetup, DummyInt, DataColumn[4], DummyCaption, 2, false);                                ValidateDataColumn(4);                            end;                            trigger OnValidate()                            begin                                ValidateDataColumn(4);                            end;                        }                        field("Aggregation[4]"; Aggregation[4])                        {                            ApplicationArea = Basic, Suite;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled;                            OptionCaption = 'None,Count,Sum,Min,Max,Avg';                            ShowCaption = false;                            trigger OnValidate()                            begin                                CheckAggregation(4);                                UpdateChartDefinition();                            end;                        }                        field("ChartTypeReduced[4]"; ChartTypeReduced[4])                        {                            ApplicationArea = Basic, Suite;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled;                            ShowCaption = false;                            trigger OnValidate()                            begin                                UpdateChartDefinition();                                EnableControls();                            end;                        }                        field("MeasureCaption[4]"; MeasureCaption[4])                        {                            ApplicationArea = Basic, Suite;                            AssistEdit = false;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled and DataColumn4Enabled;                            ShowCaption = false;                            trigger OnAssistEdit()                            begin                                MeasureCaption[4] := GenericChartMgt.TextMLAssistEdit(TempGenericChartCaptionsBuf, GenericChartMgt.OptionalMeasure3Code());                                UpdateChartDefinition();                            end;                            trigger OnValidate()                            begin                                TempGenericChartCaptionsBuf.SetCaption(GenericChartMgt.OptionalMeasure3Code(), GenericChartMgt.GetUserLanguage(), MeasureCaption[4]);                                UpdateChartDefinition();                            end;                        }                    }                    group("Optional Measure 4")                    {                        Caption = 'Optional Measure';                        field("DataColumn[5]"; DataColumn[5])                        {                            ApplicationArea = Basic, Suite;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled and DataColumn5Enabled;                            ShowCaption = false;                            trigger OnLookup(var Text: Text): Boolean                            begin                                GenericChartMgt.RetrieveFieldColumn(TempGenericChartSetup, DummyInt, DataColumn[5], DummyCaption, 2, false);                                ValidateDataColumn(5);                            end;                            trigger OnValidate()                            begin                                ValidateDataColumn(5);                            end;                        }                        field("Aggregation[5]"; Aggregation[5])                        {                            ApplicationArea = Basic, Suite;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled;                            OptionCaption = 'None,Count,Sum,Min,Max,Avg';                            ShowCaption = false;                            trigger OnValidate()                            begin                                CheckAggregation(5);                                UpdateChartDefinition();                            end;                        }                        field("ChartTypeReduced[5]"; ChartTypeReduced[5])                        {                            ApplicationArea = Basic, Suite;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled;                            OptionCaption = 'Column,Point,Line,ColumnStacked,ColumnStacked100,Area,AreaStacked,AreaStacked100,StepLine,,,Range';                            ShowCaption = false;                            trigger OnValidate()                            begin                                UpdateChartDefinition();                                EnableControls();                            end;                        }                        field("MeasureCaption[5]"; MeasureCaption[5])                        {                            ApplicationArea = Basic, Suite;                            AssistEdit = false;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled and DataColumn5Enabled;                            ShowCaption = false;                            trigger OnAssistEdit()                            begin                                MeasureCaption[5] := GenericChartMgt.TextMLAssistEdit(TempGenericChartCaptionsBuf, GenericChartMgt.OptionalMeasure4Code());                                UpdateChartDefinition();                            end;                            trigger OnValidate()                            begin                                TempGenericChartCaptionsBuf.SetCaption(GenericChartMgt.OptionalMeasure4Code(), GenericChartMgt.GetUserLanguage(), MeasureCaption[5]);                                UpdateChartDefinition();                            end;                        }                    }                    group("Optional Measure 5")                    {                        Caption = 'Optional Measure';                        field("DataColumn[6]"; DataColumn[6])                        {                            ApplicationArea = Basic, Suite;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled and DataColumn6Enabled;                            ShowCaption = false;                            trigger OnLookup(var Text: Text): Boolean                            begin                                GenericChartMgt.RetrieveFieldColumn(TempGenericChartSetup, DummyInt, DataColumn[6], DummyCaption, 2, false);                                ValidateDataColumn(6);                            end;                            trigger OnValidate()                            begin                                ValidateDataColumn(6);                            end;                        }                        field("Aggregation[6]"; Aggregation[6])                        {                            ApplicationArea = Basic, Suite;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled;                            OptionCaption = 'None,Count,Sum,Min,Max,Avg';                            ShowCaption = false;                            trigger OnValidate()                            begin                                CheckAggregation(6);                                UpdateChartDefinition();                            end;                        }                        field("ChartTypeReduced[6]"; ChartTypeReduced[6])                        {                            ApplicationArea = Basic, Suite;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled;                            OptionCaption = 'Column,Point,Line,ColumnStacked,ColumnStacked100,Area,AreaStacked,AreaStacked100,StepLine,,,Range';                            ShowCaption = false;                            trigger OnValidate()                            begin                                UpdateChartDefinition();                                EnableControls();                            end;                        }                        field("MeasureCaption[6]"; MeasureCaption[6])                        {                            ApplicationArea = Basic, Suite;                            AssistEdit = false;                            Editable = OptionalMeasuresEnabled;                            Enabled = OptionalMeasuresEnabled and DataColumn6Enabled;                            ShowCaption = false;                            trigger OnAssistEdit()                            begin                                MeasureCaption[6] := GenericChartMgt.TextMLAssistEdit(TempGenericChartCaptionsBuf, GenericChartMgt.OptionalMeasure5Code());                                UpdateChartDefinition();                            end;                            trigger OnValidate()                            begin                                TempGenericChartCaptionsBuf.SetCaption(GenericChartMgt.OptionalMeasure5Code(), GenericChartMgt.GetUserLanguage(), MeasureCaption[6]);                                UpdateChartDefinition();                            end;                        }                    }                }                field("Y-Axis Title"; TempGenericChartSetup."Y-Axis Title")                {                    ApplicationArea = Basic, Suite;                    AssistEdit = false;                    Caption = 'Y-Axis Title';                    ToolTip = 'Specifies the text that is shown next to the y-axis on the generic chart. To specify y-axis titles in different languages, choose the AssistEdit button to open the Generic Chart Text Editor window.';                    trigger OnAssistEdit()                    begin                        TempGenericChartSetup."Y-Axis Title" :=                          GenericChartMgt.TextMLAssistEdit(TempGenericChartCaptionsBuf, GenericChartMgt.YAxisTitleCode());                        UpdateChartDefinition();                    end;                    trigger OnValidate()                    begin                        TempGenericChartCaptionsBuf.SetCaption(GenericChartMgt.YAxisTitleCode(), GenericChartMgt.GetUserLanguage(),                          TempGenericChartSetup."Y-Axis Title");                        UpdateChartDefinition();                    end;                }                field("Show Y-Axis Title"; TempGenericChartSetup."Y-Axis Show Title")                {                    ApplicationArea = Basic, Suite;                    Caption = 'Show Y-Axis Title';                    ToolTip = 'Specifies if the value in the Y-Axis Title field is shown on the generic chart.';                    trigger OnValidate()                    var                        GenericChartMgt: Codeunit "Generic Chart Mgt";                    begin                        GenericChartMgt.CheckSourceTypeID(TempGenericChartSetup, true);                        UpdateChartDefinition();                    end;                }            }            group("<Control35>")            {                Caption = 'Dimensions (X- and Z-Axes)';                field("X-Axis Field"; TempGenericChartSetup."X-Axis Field Name")                {                    ApplicationArea = Basic, Suite;                    Caption = 'X-Axis Field';                    ToolTip = 'Specifies the field in the source object that is shown on the x-axis of the generic chart. The text is shown as a tooltip when you hover over the data element on the chart.';                    trigger OnLookup(var Text: Text): Boolean                    var                        GenericChartMgt: Codeunit "Generic Chart Mgt";                    begin                        GenericChartMgt.RetrieveFieldColumn(TempGenericChartSetup, TempGenericChartSetup."X-Axis Field ID", TempGenericChartSetup."X-Axis Field Name", TempGenericChartSetup."X-Axis Title", 0, false);                        TempGenericChartCaptionsBuf.SetCaption(GenericChartMgt.XAxisTitleCode(), GenericChartMgt.GetUserLanguage(),                          TempGenericChartSetup."X-Axis Title");                        ValidateDimension(1);                    end;                    trigger OnValidate()                    begin                        ValidateDimension(1);                    end;                }                field("X-Axis Title"; TempGenericChartSetup."X-Axis Title")                {                    ApplicationArea = Basic, Suite;                    AssistEdit = false;                    Caption = 'X-Axis Title';                    ToolTip = 'Specifies the text that describes the data that is shown on the x-axis. The text is shown as a tooltip when you hover over the data element on the chart. To specify x-axis titles in different languages, choose the AssistEdit button to open the Generic Chart Text Editor window.';                    trigger OnAssistEdit()                    begin                        TempGenericChartSetup."X-Axis Title" :=                          GenericChartMgt.TextMLAssistEdit(TempGenericChartCaptionsBuf, GenericChartMgt.XAxisTitleCode());                        UpdateChartDefinition();                    end;                    trigger OnValidate()                    begin                        TempGenericChartCaptionsBuf.SetCaption(GenericChartMgt.XAxisTitleCode(), GenericChartMgt.GetUserLanguage(),                          TempGenericChartSetup."X-Axis Title");                        UpdateChartDefinition();                    end;                }                field("Show X-Axis Title"; TempGenericChartSetup."X-Axis Show Title")                {                    ApplicationArea = Basic, Suite;                    Caption = 'Show X-Axis Title';                    ToolTip = 'Specifies if the value in the X-Axis Title field is shown on the generic chart.';                    trigger OnValidate()                    var                        GenericChartMgt: Codeunit "Generic Chart Mgt";                    begin                        GenericChartMgt.CheckSourceTypeID(TempGenericChartSetup, true);                        UpdateChartDefinition();                    end;                }                field("Data Point X Label"; TempGenericChartSetup."X-Axis Field Caption")                {                    ApplicationArea = Basic, Suite;                    AssistEdit = false;                    Caption = 'Data Point X Label';                    ToolTip = 'Specifies the text describes the selected x-axis value in a tooltip when you hover over a data point. The data point label is shown in front of the data value.';                    trigger OnAssistEdit()                    begin                        TempGenericChartSetup."X-Axis Field Caption" :=                          GenericChartMgt.TextMLAssistEdit(TempGenericChartCaptionsBuf, GenericChartMgt.XAxisCaptionCode());                        UpdateChartDefinition();                    end;                    trigger OnValidate()                    begin                        TempGenericChartCaptionsBuf.SetCaption(GenericChartMgt.XAxisCaptionCode(), GenericChartMgt.GetUserLanguage(),                          TempGenericChartSetup."X-Axis Field Caption");                        UpdateChartDefinition();                    end;                }                field("Z-Axis Field"; TempGenericChartSetup."Z-Axis Field Name")                {                    ApplicationArea = Basic, Suite;                    Caption = 'Z-Axis Field';                    Editable = ZAxisEnabled;                    Enabled = ZAxisEnabled;                    ToolTip = 'Specifies the field in the source object that is shown on the z-axis of the generic chart.';                    trigger OnLookup(var Text: Text): Boolean                    var                        GenericChartMgt: Codeunit "Generic Chart Mgt";                    begin                        GenericChartMgt.RetrieveFieldColumn(TempGenericChartSetup, TempGenericChartSetup."Z-Axis Field ID", TempGenericChartSetup."Z-Axis Field Name", TempGenericChartSetup."Z-Axis Title", 0, false);                        ValidateDimension(2);                    end;                    trigger OnValidate()                    begin                        ValidateDimension(2);                    end;                }                field("Data Point Z Label"; TempGenericChartSetup."Z-Axis Field Caption")                {                    ApplicationArea = Basic, Suite;                    AssistEdit = false;                    Caption = 'Data Point Z Label';                    ToolTip = 'Specifies the text that describes the z-axis value in a tooltip when you hover over a data point. The data point label is shown in front of the data value.';                    trigger OnAssistEdit()                    begin                        TempGenericChartSetup."Z-Axis Field Caption" :=                          GenericChartMgt.TextMLAssistEdit(TempGenericChartCaptionsBuf, GenericChartMgt.ZAxisCaptionCode());                        UpdateChartDefinition();                    end;                    trigger OnValidate()                    begin                        TempGenericChartCaptionsBuf.SetCaption(GenericChartMgt.ZAxisCaptionCode(), GenericChartMgt.GetUserLanguage(),                          TempGenericChartSetup."Z-Axis Field Caption");                        UpdateChartDefinition();                    end;                }            }            group("Chart Description")            {                Caption = 'Chart Description';                field(Description; ChartDescription)                {                    ApplicationArea = Basic, Suite;                    AssistEdit = false;                    Caption = 'Description';                    Editable = TitleEnabled;                    MultiLine = true;                    ToolTip = 'Specifies a description of the generic chart.';                    trigger OnAssistEdit()                    begin                        ChartDescription := GenericChartMgt.MemoMLAssistEdit(TempGenericChartMemoBuf, GenericChartMgt.DescriptionCode());                        UpdateChartDefinition();                    end;                    trigger OnValidate()                    begin                        TempGenericChartMemoBuf.SetMemo(GenericChartMgt.DescriptionCode(), GenericChartMgt.GetUserLanguage(), ChartDescription);                        UpdateChartDefinition();                    end;                }            }            part(PreviewPart; "Generic Chart Type Preview")            {                ApplicationArea = Basic, Suite;                Caption = 'Preview Part';            }        }    }    actions    {        area(processing)        {            action("E&xport Chart")            {                ApplicationArea = Basic, Suite;                Caption = 'E&xport Chart';                Ellipsis = true;                Image = Export;                ToolTip = 'Export a generic chart in XML format. You can rename the file, modify the chart definition using an XML editor, and then import the new chart into another client.';                trigger OnAction()                begin                    ExportChartDefinition();                end;            }            action("Copy Chart")            {                ApplicationArea = Basic, Suite;                Caption = 'Copy Chart';                Ellipsis = true;                Image = Copy;                ToolTip = 'Copy an existing chart to create a new generic chart.';                trigger OnAction()                var                    CopyGenericChart: Page "Copy Generic Chart";                begin                    Rec.CalcFields(BLOB);                    CopyGenericChart.SetSourceChart(Rec);                    CopyGenericChart.RunModal();                end;            }        }        area(navigation)        {        }        area(Promoted)        {            group(Category_Process)            {                Caption = 'Process';                actionref("E&xport Chart_Promoted"; "E&xport Chart")                {                }                actionref("Copy Chart_Promoted"; "Copy Chart")                {                }            }        }    }    trigger OnAfterGetRecord()    begin        if not XMLRetrieved then begin            SetFieldValues();            EnableControls();        end;        XMLRetrieved := true;    end;    var        TempGenericChartSetup: Record "Generic Chart Setup" temporary;        TempGenericChartFilter: Record "Generic Chart Filter" temporary;        TempGenericChartYAxis: Record "Generic Chart Y-Axis" temporary;        TempGenericChartCaptionsBuf: Record "Generic Chart Captions Buffer" temporary;        TempGenericChartMemoBuf: Record "Generic Chart Memo Buffer" temporary;        GenericChartMgt: Codeunit "Generic Chart Mgt";        DataColumn: array[6] of Text[50];        MeasureCaption: array[6] of Text[250];        Aggregation: array[6] of Option "None","Count","Sum","Min","Max",Avg;        ChartType: Option Column,Point,Line,ColumnStacked,ColumnStacked100,"Area",AreaStacked,AreaStacked100,StepLine,Pie,Doughnut,Range,Radar,Funnel;        ChartTypeReduced: array[6] of Option Column,Point,Line,ColumnStacked,ColumnStacked100,"Area",AreaStacked,AreaStacked100,StepLine,,,Range;        ChartDescription: Text;        DummyInt: Integer;        DummyCaption: Text[50];        OptionalMeasuresEnabled: Boolean;#pragma warning disable AA0470        FieldAlreadyAssignedErr: Label 'Field %1 is already assigned to a measure or dimension. Select a different field.';#pragma warning restore AA0470        ZAxisEnabled: Boolean;        OnlyOneCountAggregationErr: Label 'You can only select one Measure with aggregation type Count.';        AggregationCountChangeQst: Label 'If you select Aggregation Count, the Data Column will be modified for this measure. Do you want to continue?';        TitleEnabled: Boolean;        XMLRetrieved: Boolean;        DataColumn1Enabled: Boolean;        DataColumn2Enabled: Boolean;        DataColumn3Enabled: Boolean;        DataColumn4Enabled: Boolean;        DataColumn5Enabled: Boolean;        DataColumn6Enabled: Boolean;    local procedure SetFieldValues()    begin        ClearAllVariables();        GenericChartMgt.RetrieveXML(          Rec, TempGenericChartSetup, TempGenericChartYAxis, TempGenericChartCaptionsBuf, TempGenericChartMemoBuf, TempGenericChartFilter);        ChartDescription := TempGenericChartMemoBuf.GetMemo(GenericChartMgt.DescriptionCode(), GenericChartMgt.GetUserLanguage());        TempGenericChartSetup."Y-Axis Title" :=          TempGenericChartCaptionsBuf.GetCaption(GenericChartMgt.YAxisTitleCode(), GenericChartMgt.GetUserLanguage());        TempGenericChartSetup."X-Axis Field Caption" :=          TempGenericChartCaptionsBuf.GetCaption(GenericChartMgt.XAxisCaptionCode(), GenericChartMgt.GetUserLanguage());        TempGenericChartSetup."X-Axis Title" :=          TempGenericChartCaptionsBuf.GetCaption(GenericChartMgt.XAxisTitleCode(), GenericChartMgt.GetUserLanguage());        TempGenericChartSetup."Z-Axis Field Caption" :=          TempGenericChartCaptionsBuf.GetCaption(GenericChartMgt.ZAxisCaptionCode(), GenericChartMgt.GetUserLanguage());        TempGenericChartSetup.Insert();        FillMatrixWhenOpenPage();        UpdateTempGenericChartYAXis();        RefreshPreview();    end;    local procedure ValidateDataColumn(Index: Integer)    var        FieldAlreadyExists: Boolean;        i: Integer;    begin        GenericChartMgt.CheckSourceTypeID(TempGenericChartSetup, true);        for i := 1 to ArrayLen(DataColumn) do            if (DataColumn[i] <> '') and (Index <> i) then                FieldAlreadyExists := (DataColumn[Index] = DataColumn[i]) or FieldAlreadyExists;        if FieldAlreadyExists then            Error(FieldAlreadyAssignedErr, DataColumn[Index]);        GenericChartMgt.CheckDataTypeAggregationCompliance(TempGenericChartSetup, DataColumn[Index], Aggregation[Index]);        GenericChartMgt.ValidateFieldColumn(TempGenericChartSetup, DummyInt, DataColumn[1], DummyCaption, 2, false, Aggregation[Index]);        UpdateChartDefinition();        EnableControls();    end;    local procedure ValidateDimension(Index: Integer)    var        DummyAggregation: Option "None","Count","Sum","Min","Max",Avg;    begin        GenericChartMgt.CheckSourceTypeID(TempGenericChartSetup, true);        if (TempGenericChartSetup."X-Axis Field Name" <> '') and (TempGenericChartSetup."Z-Axis Field Name" <> '') and (TempGenericChartSetup."X-Axis Field Name" = TempGenericChartSetup."Z-Axis Field Name") then            Error(FieldAlreadyAssignedErr, DataColumn[Index]);        case Index of            1:                GenericChartMgt.ValidateFieldColumn(                  TempGenericChartSetup, TempGenericChartSetup."X-Axis Field ID", TempGenericChartSetup."X-Axis Field Name", TempGenericChartSetup."X-Axis Title", 0, false, DummyAggregation);            2:                GenericChartMgt.ValidateFieldColumn(                  TempGenericChartSetup, TempGenericChartSetup."Z-Axis Field ID", TempGenericChartSetup."Z-Axis Field Name", TempGenericChartSetup."Z-Axis Title", 0, false, DummyAggregation);        end;        UpdateChartDefinition();        EnableControls();    end;    local procedure UpdateTempGenericChartYAXis()    var        i: Integer;        "Count": Integer;    begin        TempGenericChartYAxis.DeleteAll();        if ChartCapableOfOptionalMeasures() then            Count := ArrayLen(DataColumn)        else            Count := 1;        for i := 1 to Count do            if AddYAxisMeasure(i) then begin                Clear(TempGenericChartYAxis);                TempGenericChartYAxis.ID := Rec.ID;                TempGenericChartYAxis."Line No." := i * 10000;                TempGenericChartYAxis."Y-Axis Measure Field Name" := DataColumn[i];                TempGenericChartYAxis."Y-Axis Measure Field Caption" := MeasureCaption[i];                GenericChartMgt.RetrieveFieldColumnIDFromName(                  TempGenericChartSetup."Source Type", TempGenericChartSetup."Source ID", TempGenericChartYAxis."Y-Axis Measure Field ID",                  DataColumn[i]);                TempGenericChartYAxis.Aggregation := Aggregation[i];                if i = 1 then                    TempGenericChartYAxis."Chart Type" := ChartType                else                    TempGenericChartYAxis."Chart Type" := ChartTypeReduced[i];                TempGenericChartYAxis.Insert();            end;    end;    local procedure FillMatrixWhenOpenPage()    var        i: Integer;        CurrentCaptionCode: Code[10];    begin        Clear(DataColumn);        Clear(MeasureCaption);        Clear(Aggregation);        Clear(ChartType);        i := 0;        if TempGenericChartYAxis.FindSet() then begin            CurrentCaptionCode := GenericChartMgt.RequiredMeasureCode();            repeat                i += 1;                DataColumn[i] := TempGenericChartYAxis."Y-Axis Measure Field Name";                MeasureCaption[i] := TempGenericChartCaptionsBuf.GetCaption(CurrentCaptionCode, GenericChartMgt.GetUserLanguage());                Aggregation[i] := TempGenericChartYAxis.Aggregation;                if i = 1 then                    ChartType := TempGenericChartYAxis."Chart Type"                else                    ChartTypeReduced[i] := TempGenericChartYAxis."Chart Type";                if CurrentCaptionCode = GenericChartMgt.RequiredMeasureCode() then                    CurrentCaptionCode := GenericChartMgt.OptionalMeasure1Code()                else                    CurrentCaptionCode := IncStr(CurrentCaptionCode)            until TempGenericChartYAxis.Next() = 0;        end    end;    local procedure UpdateChartDefinition()    begin        UpdateTempGenericChartYAXis();        GenericChartMgt.SaveChanges(Rec, TempGenericChartSetup, TempGenericChartYAxis, TempGenericChartFilter,          TempGenericChartCaptionsBuf, TempGenericChartMemoBuf);        EnableControls();        RefreshPreview();    end;    local procedure RefreshPreview()    var        chartBuilder: DotNet BusinessChartBuilder;    begin        chartBuilder := chartBuilder.Empty();        GenericChartMgt.FillChartHelper(chartBuilder, TempGenericChartSetup, TempGenericChartYAxis, TempGenericChartFilter,          TempGenericChartCaptionsBuf, TempGenericChartMemoBuf);        CurrPage.PreviewPart.PAGE.SetChartDefinition(chartBuilder);    end;    local procedure ClearAllVariables()    begin        TempGenericChartSetup.DeleteAll();        TempGenericChartFilter.DeleteAll();        TempGenericChartYAxis.DeleteAll();        TempGenericChartCaptionsBuf.DeleteAll();        TempGenericChartMemoBuf.DeleteAll();        Clear(TempGenericChartFilter);        Clear(TempGenericChartYAxis);        Clear(TempGenericChartSetup);        Clear(TempGenericChartCaptionsBuf);        Clear(TempGenericChartMemoBuf);        Clear(GenericChartMgt);        Clear(DataColumn);        Clear(MeasureCaption);        Clear(Aggregation);        Clear(ChartType);        Clear(ChartTypeReduced);        Clear(DummyInt);        Clear(DummyCaption);    end;    local procedure ChartCapableOfOptionalMeasures(): Boolean    begin        exit(not (ChartType in [ChartType::Pie, ChartType::Doughnut, ChartType::Funnel, ChartType::Radar]));    end;    local procedure ExportChartDefinition()    var        TempBlob: Codeunit "Temp Blob";        FileMgt: Codeunit "File Management";    begin        TempBlob.FromRecord(Rec, Rec.FieldNo(BLOB));        if TempBlob.HasValue() then            FileMgt.BLOBExport(TempBlob, '*.xml', true);    end;    local procedure EnableControls()    begin        OptionalMeasuresEnabled := ChartCapableOfOptionalMeasures() and (TempGenericChartSetup."Z-Axis Field Name" = '');        ZAxisEnabled :=          ChartCapableOfOptionalMeasures() and          (DataColumn[2] = '') and (DataColumn[3] = '') and (DataColumn[4] = '') and (DataColumn[5] = '') and (DataColumn[6] = '');        TitleEnabled := true;        DataColumn1Enabled := Aggregation[1] <> Aggregation[1] ::Count;        DataColumn2Enabled := Aggregation[2] <> Aggregation[2] ::Count;        DataColumn3Enabled := Aggregation[3] <> Aggregation[3] ::Count;        DataColumn4Enabled := Aggregation[4] <> Aggregation[4] ::Count;        DataColumn5Enabled := Aggregation[5] <> Aggregation[5] ::Count;        DataColumn6Enabled := Aggregation[6] <> Aggregation[6] ::Count;    end;    local procedure AddYAxisMeasure(index: Integer): Boolean    begin        if Aggregation[index] = Aggregation[index] ::Count then            exit(true);        exit(DataColumn[index] <> '');    end;    local procedure CheckAggregation(index: Integer)    var        i: Integer;        FieldOfTypeCountAlreadyExists: Boolean;        CountColumnName: Text[50];        ReplaceDataColumn: Boolean;    begin        for i := 1 to ArrayLen(Aggregation) do            if (Aggregation[i] = Aggregation[i] ::Count) and (index <> i) then                FieldOfTypeCountAlreadyExists := (Aggregation[index] = Aggregation[i]) or FieldOfTypeCountAlreadyExists;        if FieldOfTypeCountAlreadyExists then            Error(OnlyOneCountAggregationErr);        GenericChartMgt.CheckDataTypeAggregationCompliance(TempGenericChartSetup, DataColumn[index], Aggregation[index]);        if Aggregation[index] = Aggregation[index] ::Count then begin            CountColumnName := GenericChartMgt.GetQueryCountColumnName(TempGenericChartSetup);            if DataColumn[index] <> CountColumnName then begin                ReplaceDataColumn := true;                if DataColumn[index] <> '' then                    ReplaceDataColumn := Confirm(AggregationCountChangeQst, false);                if ReplaceDataColumn then                    DataColumn[index] := CountColumnName                else                    Error('');            end;        end;    end;}