Page 9183 Generic Chart Setup
src/Layers/W1/BaseApp/System/GenericChart/GenericChartSetup.Page.al1,199 lines, Copyright (c) Microsoft Corporation. MIT
namespace System.Visualization;using System;using System.IO;using System.Reflection;using System.Utilities;page 9183 "Generic Chart Setup"{ Caption = 'Generic Chart Setup'; PageType = Card; SourceTable = Chart; layout { area(content) { group(General) { Caption = 'General'; field(ID; Rec.ID) { ApplicationArea = Basic, Suite; NotBlank = true; ToolTip = 'Specifies the unique ID of the chart.'; } field(Name; Rec.Name) { ApplicationArea = Basic, Suite; ToolTip = 'Specifies the name of the chart.'; } field(ChartExists; Rec.BLOB.HasValue) { ApplicationArea = Basic, Suite; Caption = 'Chart Exists'; ToolTip = 'Specifies that one or more charts have been created from the generic chart. '; Visible = false; } } group("Data Source") { Caption = 'Data Source'; field("Source Type"; TempGenericChartSetup."Source Type") { ApplicationArea = Basic, Suite; Caption = 'Source Type'; ToolTip = 'Specifies the source type for the chart.'; trigger OnLookup(var Text: Text): Boolean var CalledFrom: Option "Source Type","Source ID"; begin ResetFields(CalledFrom::"Source Type"); UpdateChartDefinition(); StoreTempXRecValues() end; trigger OnValidate() var CalledFrom: Option "Source Type","Source ID"; begin ResetFields(CalledFrom::"Source Type"); UpdateChartDefinition(); StoreTempXRecValues() end; } field("Source ID"; TempGenericChartSetup."Source ID") { ApplicationArea = Basic, Suite; Caption = 'Source ID'; ToolTip = 'Specifies the source ID for the chart.'; trigger OnLookup(var Text: Text): Boolean var GenericChartMgt: Codeunit "Generic Chart Mgt"; CalledFrom: Option "Source Type","Source ID"; begin GenericChartMgt.CheckSourceTypeID(TempGenericChartSetup, false); GenericChartMgt.LookUpObjectId( TempGenericChartSetup."Source Type", TempGenericChartSetup."Source ID", TempGenericChartSetup."Object Name"); ResetFields(CalledFrom::"Source ID"); GenericChartMgt.ValidateObjectID( TempGenericChartSetup."Source Type", TempGenericChartSetup."Source ID", TempGenericChartSetup."Object Name"); UpdateChartDefinition(); StoreTempXRecValues() end; trigger OnValidate() var GenericChartMgt: Codeunit "Generic Chart Mgt"; CalledFrom: Option "Source Type","Source ID"; begin ResetFields(CalledFrom::"Source ID"); GenericChartMgt.ValidateObjectID( TempGenericChartSetup."Source Type", TempGenericChartSetup."Source ID", TempGenericChartSetup."Object Name"); UpdateChartDefinition(); StoreTempXRecValues() end; } field("Source Name"; TempGenericChartSetup."Object Name") { ApplicationArea = Basic, Suite; Caption = 'Source Name'; Editable = false; ToolTip = 'Specifies the source name for the chart.'; trigger OnValidate() begin UpdateChartDefinition(); end; }#pragma warning disable AA0100 field("TempGenericChartSetup.""Filter Text"""; TempGenericChartSetup."Filter Text")#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; Caption = 'Filters'; Editable = false; ToolTip = 'Specifies the field filters which delimit the field values that the chart is based on.'; trigger OnAssistEdit() begin ShowChartFiltersPage(); CurrPage.Update(); end; } } 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(RequiredMeasureColumn; 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(RequiredMeasureAggregation; 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(RequiredMeasureType; 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(RequiredMeasureCaption; MeasureCaption[1]) { ApplicationArea = Basic, Suite; Caption = 'Data Point Label'; ColumnSpan = 1; Editable = DataColumn1Enabled; Enabled = DataColumn1Enabled; RowSpan = 1; ToolTip = 'Specifies the text that describes the selected y-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 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(OptionalMeasureColumn1; 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(OptionalMeasureAggregation1; 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(OptionalMeasureType1; 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(OptionalMeasureCaption1; MeasureCaption[2]) { ApplicationArea = Basic, Suite; 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(OptionalMeasureColumn2; 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(OptionalMeasureAggregation2; 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(OptionalMeasureType2; 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(OptionalMeasureCaption2; MeasureCaption[3]) { ApplicationArea = Basic, Suite; 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(OptionalMeasureColumn3; 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(OptionalMeasureAggregation3; 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(OptionalMeasureType3; ChartTypeReduced[4]) { 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(OptionalMeasureCaption3; MeasureCaption[4]) { ApplicationArea = Basic, Suite; 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(OptionalMeasureColumn4; 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(OptionalMeasureAggregation4; 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(OptionalMeasureType4; 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(OptionalMeasureCaption4; MeasureCaption[5]) { ApplicationArea = Basic, Suite; 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(OptionalMeasureColumn5; 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(OptionalMeasureAggregation5; 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(OptionalMeasureType5; 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(OptionalMeasureCaption5; MeasureCaption[6]) { ApplicationArea = Basic, Suite; 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; 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(Dimensions) { 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; 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; 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; 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; 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("Import Chart") { ApplicationArea = Basic, Suite; Caption = 'Import Chart'; Ellipsis = true; Image = Import; ToolTip = 'Import a generic chart in XML format.'; trigger OnAction() begin ImportChartDefinition(); end; } 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 CopyGenericChart.SetSourceChart(Rec); CopyGenericChart.RunModal(); end; } } area(navigation) { action(Filters) { ApplicationArea = Basic, Suite; Caption = 'Filters'; Image = EditFilter; ToolTip = 'Filter on the generic charts.'; trigger OnAction() begin ShowChartFiltersPage(); CurrPage.Update(); end; } } area(Promoted) { group(Category_Process) { Caption = 'Process'; actionref("Import Chart_Promoted"; "Import Chart") { } actionref("E&xport Chart_Promoted"; "E&xport Chart") { } actionref("Copy Chart_Promoted"; "Copy Chart") { } actionref(Filters_Promoted; Filters) { } } } } trigger OnAfterGetRecord() begin SetFieldValues(); EnableControls(); 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; xRecSourceType: Option " ","Table","Query"; xRecSourceID: Integer; DummyInt: Integer; DummyCaption: Text[50];#pragma warning disable AA0470 ResetFieldsQst: Label 'All fields will be reset. Are you sure that you want to change the %1?';#pragma warning restore AA0470 OptionalMeasuresEnabled: Boolean;#pragma warning disable AA0470 FieldAlreadyAssignedErr: Label 'Field %1 is already assigned to a measure or dimension. Select a different field.'; ReplaceChartDefinitionQst: Label 'Do you want to replace the existing definition for %1 %2?', Comment = 'Do you want to replace the existing definition for Chart 36-06?';#pragma warning restore AA0470 DataColumn1Enabled: Boolean; DataColumn2Enabled: Boolean; DataColumn3Enabled: Boolean; DataColumn4Enabled: Boolean; DataColumn5Enabled: Boolean; DataColumn6Enabled: Boolean; ZAxisEnabled: Boolean; OnlyOneCountAggregationErr: Label 'You can only specify one Measure with aggregation type Count.'; AggregationCountChangeQst: Label 'If you select Aggregation Count, the Data Column will be cleared for this measure. Do you want to continue?'; TitleEnabled: 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(); StoreTempXRecValues(); 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[Index], 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]; GenericChartMgt.RetrieveFieldColumnIDFromName( TempGenericChartSetup."Source Type", TempGenericChartSetup."Source ID", TempGenericChartYAxis."Y-Axis Measure Field ID", DataColumn[i]); TempGenericChartYAxis."Y-Axis Measure Field Caption" := MeasureCaption[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 if ChartDefinitionCreationIsPossible() then begin UpdateTempGenericChartYAXis(); GenericChartMgt.SaveChanges(Rec, TempGenericChartSetup, TempGenericChartYAxis, TempGenericChartFilter, TempGenericChartCaptionsBuf, TempGenericChartMemoBuf); end; EnableControls(); RefreshPreview(); end; local procedure ChartDefinitionCreationIsPossible(): Boolean begin exit((TempGenericChartSetup."Source Type" <> TempGenericChartSetup."Source Type"::" ") and (TempGenericChartSetup."Source ID" <> 0)); end; local procedure RefreshPreview() var chartBuilder: DotNet BusinessChartBuilder; begin if ChartDefinitionCreationIsPossible() then begin chartBuilder := chartBuilder.Empty(); GenericChartMgt.FillChartHelper(chartBuilder, TempGenericChartSetup, TempGenericChartYAxis, TempGenericChartFilter, TempGenericChartCaptionsBuf, TempGenericChartMemoBuf); CurrPage.PreviewPart.PAGE.SetChartDefinition(chartBuilder); end; end; local procedure ShowChartFiltersPage() var TempGenericChartFilter2: Record "Generic Chart Filter" temporary; GenericChartFiltersPage: Page "Generic Chart Filters"; FilterText: Text[250]; begin GenericChartMgt.CheckSourceTypeID(TempGenericChartSetup, true); GenericChartFiltersPage.SetTempGenericChart(TempGenericChartSetup); GenericChartFiltersPage.SetFilters(TempGenericChartFilter); GenericChartFiltersPage.SetTableView(TempGenericChartFilter); Commit(); GenericChartFiltersPage.RunModal(); TempGenericChartFilter.DeleteAll(); Clear(FilterText); GenericChartFiltersPage.GetFilters(TempGenericChartFilter2); if TempGenericChartFilter2.FindSet() then repeat TempGenericChartFilter := TempGenericChartFilter2; TempGenericChartFilter.Insert(); if TempGenericChartFilter."Filter Value" <> '' then GenericChartMgt.BuildFilterText(FilterText, CopyStr( TempGenericChartFilter."Filter Field Name" + ' : ' + TempGenericChartFilter."Filter Value", 1, MaxStrLen(FilterText))); until TempGenericChartFilter2.Next() = 0; GenericChartMgt.FinalizeFilterText(FilterText); TempGenericChartSetup."Filter Text" := FilterText; if TempGenericChartSetup.Modify() then; UpdateChartDefinition(); end; local procedure ResetFields(CalledFrom: Option "Source Type","Source ID") var ID: Code[20]; SourceType: Option; SourceID: Integer; begin ID := TempGenericChartSetup.ID; SourceType := TempGenericChartSetup."Source Type"; SourceID := TempGenericChartSetup."Source ID"; case CalledFrom of CalledFrom::"Source Type": begin if TempGenericChartSetup."Source Type" = xRecSourceType then exit; if xRecSourceType <> xRecSourceType::" " then if not Confirm(ResetFieldsQst, true, TempGenericChartSetup.FieldCaption("Source Type")) then Error(''); end; CalledFrom::"Source ID": begin if TempGenericChartSetup."Source ID" = xRecSourceID then exit; if xRecSourceID <> 0 then if not Confirm(ResetFieldsQst, true, TempGenericChartSetup.FieldCaption("Source ID")) then Error(''); end; end; ClearAllVariables(); TempGenericChartSetup.ID := ID; TempGenericChartSetup."Source Type" := SourceType; if CalledFrom = CalledFrom::"Source ID" then TempGenericChartSetup."Source ID" := SourceID; 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 StoreTempXRecValues() begin xRecSourceType := TempGenericChartSetup."Source Type"; xRecSourceID := TempGenericChartSetup."Source ID"; end; local procedure ImportChartDefinition() var TempBlob: Codeunit "Temp Blob"; FileMgt: Codeunit "File Management"; RecordRef: RecordRef; begin if FileMgt.BLOBImport(TempBlob, '*.xml') = '' then exit; if Rec.BLOB.HasValue() then if not Confirm(ReplaceChartDefinitionQst, false, Rec.TableCaption(), Rec.ID) then exit; RecordRef.GetTable(Rec); TempBlob.ToRecordRef(RecordRef, Rec.FieldNo(BLOB)); RecordRef.SetTable(Rec); CurrPage.SaveRecord(); 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 := ChartDefinitionCreationIsPossible(); 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 FieldOfTypeCountAlreadyExists: Boolean; i: Integer; 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;}