Table 770 Analysis Report Chart Setup
src/Layers/W1/BaseApp/Inventory/Analysis/AnalysisReportChartSetup.Table.al429 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Inventory.Analysis;using System.Visualization;table 770 "Analysis Report Chart Setup"{ Caption = 'Analysis Report Chart Setup'; LookupPageID = "Analysis Report Chart List"; DataClassification = CustomerContent; fields { field(1; "User ID"; Text[132]) { Caption = 'User ID'; ToolTip = 'Specifies the ID of the user who posted the entry, to be used, for example, in the change log.'; DataClassification = EndUserIdentifiableInformation; Editable = false; } field(2; Name; Text[30]) { Caption = 'Name'; ToolTip = 'Specifies the name of the specific chart.'; } field(10; "Analysis Area"; Enum "Analysis Area Type") { Caption = 'Analysis Area'; ToolTip = 'Specifies if the analysis report chart shows values for sales, purchase, or inventory.'; Editable = false; } field(20; "Analysis Report Name"; Code[10]) { Caption = 'Analysis Report Name'; ToolTip = 'Specifies the name of the analysis report that is used to generate the specific chart that is shown in, for example, the Sales Performance window.'; TableRelation = "Analysis Report Name".Name where("Analysis Area" = field("Analysis Area")); trigger OnValidate() var AnalysisReportName: Record "Analysis Report Name"; AnalysisReportChartMgt: Codeunit "Analysis Report Chart Mgt."; begin AnalysisReportName.Get("Analysis Area", "Analysis Report Name"); "Analysis Line Template Name" := AnalysisReportName."Analysis Line Template Name"; "Analysis Column Template Name" := AnalysisReportName."Analysis Column Template Name"; AnalysisReportChartMgt.CheckDuplicateAnalysisLineDescription("Analysis Area".AsInteger(), "Analysis Line Template Name"); AnalysisReportChartMgt.CheckDuplicateAnalysisColumnHeader("Analysis Area".AsInteger(), "Analysis Column Template Name"); RefreshLines(false); end; } field(21; "Analysis Line Template Name"; Code[10]) { Caption = 'Analysis Line Template Name'; ToolTip = 'Specifies the name of the analysis line template that is used to generate the specific chart that is shown in, for example, the Sales Performance window.'; Editable = false; TableRelation = "Analysis Report Name"."Analysis Line Template Name" where("Analysis Area" = field("Analysis Area"), Name = field("Analysis Report Name")); trigger OnLookup() var AnalysisLineTemplate: Record "Analysis Line Template"; AnalysisLineTemplate2: Record "Analysis Line Template"; begin AnalysisLineTemplate.SetRange("Analysis Area", "Analysis Area"); AnalysisLineTemplate2.Get("Analysis Area", "Analysis Line Template Name"); AnalysisLineTemplate := AnalysisLineTemplate2; PAGE.RunModal(0, AnalysisLineTemplate); end; } field(22; "Analysis Column Template Name"; Code[10]) { Caption = 'Analysis Column Template Name'; ToolTip = 'Specifies the name of the analysis column template that is used to generate the chart that is shown in, for example, the Sales Performance window.'; Editable = false; TableRelation = "Analysis Report Name"."Analysis Column Template Name" where("Analysis Area" = field("Analysis Area"), Name = field("Analysis Report Name")); trigger OnLookup() var AnalysisColumnTemplate: Record "Analysis Column Template"; AnalysisColumnTemplate2: Record "Analysis Column Template"; begin AnalysisColumnTemplate.SetRange("Analysis Area", "Analysis Area"); AnalysisColumnTemplate2.Get("Analysis Area", "Analysis Column Template Name"); AnalysisColumnTemplate := AnalysisColumnTemplate2; PAGE.RunModal(0, AnalysisColumnTemplate); end; } field(30; "Base X-Axis on"; Option) { Caption = 'Base X-Axis on'; ToolTip = 'Specifies how the values from the selected analysis report are displayed in the specific chart.'; OptionCaption = 'Period,Line,Column'; OptionMembers = Period,Line,Column; trigger OnValidate() begin RefreshLines(false); if "End Date" = 0D then "End Date" := "Start Date"; end; } field(31; "Start Date"; Date) { Caption = 'Start Date'; ToolTip = 'Specifies the first date on which analysis report values are included in the chart.'; trigger OnValidate() begin TestField("Start Date"); end; } field(32; "End Date"; Date) { Caption = 'End Date'; ToolTip = 'Specifies the last date on which analysis report values are included in the chart.'; trigger OnValidate() begin TestField("End Date"); end; } field(41; "Period Length"; Option) { Caption = 'Period Length'; ToolTip = 'Specifies the length of periods in the chart.'; OptionCaption = 'Day,Week,Month,Quarter,Year'; OptionMembers = Day,Week,Month,Quarter,Year; } field(42; "No. of Periods"; Integer) { Caption = 'No. of Periods'; ToolTip = 'Specifies how many periods are shown in the chart.'; InitValue = 12; trigger OnValidate() begin if "No. of Periods" < 1 then Error(Text002, FieldCaption("No. of Periods"), "No. of Periods"); end; } field(50; "Last Viewed"; Boolean) { Caption = 'Last Viewed'; Editable = false; trigger OnValidate() var AnalysisReportChartSetup: Record "Analysis Report Chart Setup"; begin if (not "Last Viewed") or ("Last Viewed" = xRec."Last Viewed") then exit; AnalysisReportChartSetup.SetRange("User ID", "User ID"); AnalysisReportChartSetup.SetRange("Analysis Area", "Analysis Area"); AnalysisReportChartSetup.SetFilter(Name, '<>%1', Name); AnalysisReportChartSetup.SetRange("Last Viewed", true); AnalysisReportChartSetup.ModifyAll("Last Viewed", false); end; } } keys { key(Key1; "User ID", "Analysis Area", Name) { Clustered = true; } } fieldgroups { } trigger OnDelete() begin DeleteLines(); end; var#pragma warning disable AA0074 Text001: Label '%1 %2', Comment = '%1=Analysis Line_Description %2=Analysis Column_Coulmn Header';#pragma warning disable AA0470 Text002: Label 'You cannot set %1 to %2.';#pragma warning restore AA0470#pragma warning restore AA0074 procedure SetAnalysisReportName(ReportName: Code[10]) begin Validate("Analysis Report Name", ReportName); Modify(true); end; procedure SetShowPer(ShowPer: Option) begin Validate("Base X-Axis on", ShowPer); Modify(true); end; procedure SetPeriodLength(PeriodLength: Option) begin "Period Length" := PeriodLength; Modify(true); end; procedure SetLastViewed() begin Validate("Last Viewed", true); Modify(true); end; procedure SetLinkToLines(var AnalysisReportChartLine: Record "Analysis Report Chart Line") begin AnalysisReportChartLine.SetRange("User ID", "User ID"); AnalysisReportChartLine.SetRange("Analysis Area", "Analysis Area"); AnalysisReportChartLine.SetRange(Name, Name); end; procedure SetLinkToMeasureLines(var AnalysisReportChartLine: Record "Analysis Report Chart Line") begin SetLinkToLines(AnalysisReportChartLine); case "Base X-Axis on" of "Base X-Axis on"::Period: ; "Base X-Axis on"::Line: AnalysisReportChartLine.SetRange("Analysis Line Line No.", 0); "Base X-Axis on"::Column: AnalysisReportChartLine.SetRange("Analysis Column Line No.", 0); end; end; procedure SetLinkToDimensionLines(var AnalysisReportChartLine: Record "Analysis Report Chart Line") begin SetLinkToLines(AnalysisReportChartLine); case "Base X-Axis on" of "Base X-Axis on"::Period: begin AnalysisReportChartLine.SetRange("Analysis Line Line No.", 0); AnalysisReportChartLine.SetRange("Analysis Column Line No.", 0); end; "Base X-Axis on"::Line: AnalysisReportChartLine.SetRange("Analysis Column Line No.", 0); "Base X-Axis on"::Column: AnalysisReportChartLine.SetRange("Analysis Line Line No.", 0); end; end; procedure RefreshLines(Force: Boolean) var AnalysisReportChartLine: Record "Analysis Report Chart Line"; TempAnalysisReportChartLine: Record "Analysis Report Chart Line" temporary; begin if not Force then if ("Analysis Report Name" = xRec."Analysis Report Name") and ("Base X-Axis on" = xRec."Base X-Axis on") then exit; GetMeasuresInTemp(TempAnalysisReportChartLine); SetLinkToLines(AnalysisReportChartLine); AnalysisReportChartLine.DeleteAll(); AnalysisReportChartLine.Reset(); if TempAnalysisReportChartLine.FindSet() then repeat AnalysisReportChartLine := TempAnalysisReportChartLine; AnalysisReportChartLine.Insert(); until TempAnalysisReportChartLine.Next() = 0; end; procedure FilterAnalysisLine(var AnalysisLine: Record "Analysis Line") begin AnalysisLine.SetRange("Analysis Area", "Analysis Area"); AnalysisLine.SetRange("Analysis Line Template Name", "Analysis Line Template Name"); AnalysisLine.SetFilter(Description, '<>%1', ''); end; procedure FilterAnalysisColumn(var AnalysisColumn: Record "Analysis Column") begin AnalysisColumn.SetRange("Analysis Area", "Analysis Area"); AnalysisColumn.SetRange("Analysis Column Template", "Analysis Column Template Name"); AnalysisColumn.SetFilter("Column Header", '<>%1', ''); end; local procedure GetMeasuresInTemp(var TempAnalysisReportChartLine: Record "Analysis Report Chart Line" temporary) var AnalysisLine: Record "Analysis Line"; AnalysisColumn: Record "Analysis Column"; begin FilterAnalysisLine(AnalysisLine); FilterAnalysisColumn(AnalysisColumn); case "Base X-Axis on" of "Base X-Axis on"::Period: if AnalysisColumn.FindSet() then repeat if AnalysisLine.FindSet() then repeat InsertLineIntoTemp(TempAnalysisReportChartLine, AnalysisLine, AnalysisColumn); until AnalysisLine.Next() = 0; until AnalysisColumn.Next() = 0; "Base X-Axis on"::Line, "Base X-Axis on"::Column: begin if AnalysisLine.FindSet() then repeat InsertLineIntoTemp(TempAnalysisReportChartLine, AnalysisLine, AnalysisColumn); until AnalysisLine.Next() = 0; Clear(AnalysisLine); if AnalysisColumn.FindSet() then repeat InsertLineIntoTemp(TempAnalysisReportChartLine, AnalysisLine, AnalysisColumn); until AnalysisColumn.Next() = 0; end; end; SetChartTypesToDefault(TempAnalysisReportChartLine); end; local procedure InsertLineIntoTemp(var TempAnalysisReportChartLine: Record "Analysis Report Chart Line" temporary; AnalysisLine: Record "Analysis Line"; AnalysisColumn: Record "Analysis Column") var AnalysisReportChartLine: Record "Analysis Report Chart Line"; begin TempAnalysisReportChartLine.Init(); TempAnalysisReportChartLine."User ID" := "User ID"; TempAnalysisReportChartLine."Analysis Area" := "Analysis Area"; TempAnalysisReportChartLine.Name := Name; TempAnalysisReportChartLine."Analysis Line Line No." := AnalysisLine."Line No."; TempAnalysisReportChartLine."Analysis Column Line No." := AnalysisColumn."Line No."; TempAnalysisReportChartLine."Analysis Line Template Name" := "Analysis Line Template Name"; TempAnalysisReportChartLine."Analysis Column Template Name" := "Analysis Column Template Name"; case "Base X-Axis on" of "Base X-Axis on"::Period: begin TempAnalysisReportChartLine."Original Measure Name" := StrSubstNo(Text001, AnalysisLine.Description, AnalysisColumn."Column Header"); TempAnalysisReportChartLine."Measure Value" := StrSubstNo(Text001, AnalysisLine."Line No.", AnalysisColumn."Line No."); end; "Base X-Axis on"::Line, "Base X-Axis on"::Column: case true of AnalysisLine."Line No." = 0: begin TempAnalysisReportChartLine."Original Measure Name" := AnalysisColumn."Column Header"; TempAnalysisReportChartLine."Measure Value" := Format(AnalysisColumn."Line No."); end; AnalysisColumn."Line No." = 0: begin TempAnalysisReportChartLine."Original Measure Name" := AnalysisLine.Description; TempAnalysisReportChartLine."Measure Value" := Format(AnalysisLine."Line No."); end; end; end; TempAnalysisReportChartLine."Measure Name" := TempAnalysisReportChartLine."Original Measure Name"; if AnalysisReportChartLine.Get(TempAnalysisReportChartLine."User ID", TempAnalysisReportChartLine."Analysis Area", TempAnalysisReportChartLine.Name, TempAnalysisReportChartLine."Analysis Line Line No.", TempAnalysisReportChartLine."Analysis Column Line No.") then TempAnalysisReportChartLine."Chart Type" := AnalysisReportChartLine."Chart Type"; TempAnalysisReportChartLine.Insert(); end; local procedure SetChartTypesToDefault(var TempAnalysisReportChartLine: Record "Analysis Report Chart Line" temporary) var TempAnalysisReportChartLine2: Record "Analysis Report Chart Line" temporary; begin TempAnalysisReportChartLine2.Copy(TempAnalysisReportChartLine, true); SetMeasureChartTypesToDefault(TempAnalysisReportChartLine2); TempAnalysisReportChartLine2.Reset(); SetLinkToDimensionLines(TempAnalysisReportChartLine2); TempAnalysisReportChartLine2.SetFilter("Chart Type", '<>%1', TempAnalysisReportChartLine2."Chart Type"::" "); if TempAnalysisReportChartLine2.IsEmpty() then SetDimensionChartTypesToDefault(TempAnalysisReportChartLine2); end; procedure SetMeasureChartTypesToDefault(var AnalysisReportChartLine: Record "Analysis Report Chart Line") var BusinessChartBuffer: Record "Business Chart Buffer"; MaxNumMeasures: Integer; NumOfMeasuresToBeSet: Integer; begin AnalysisReportChartLine.Reset(); SetLinkToMeasureLines(AnalysisReportChartLine); AnalysisReportChartLine.SetFilter("Chart Type", '<>%1', AnalysisReportChartLine."Chart Type"::" "); MaxNumMeasures := BusinessChartBuffer.GetMaxNumberOfMeasures(); NumOfMeasuresToBeSet := MaxNumMeasures - AnalysisReportChartLine.Count(); if NumOfMeasuresToBeSet > 0 then begin AnalysisReportChartLine.SetRange("Chart Type", AnalysisReportChartLine."Chart Type"::" "); if AnalysisReportChartLine.FindSet() then repeat AnalysisReportChartLine."Chart Type" := AnalysisReportChartLine.GetDefaultChartType(); AnalysisReportChartLine.Modify(); NumOfMeasuresToBeSet -= 1; until (NumOfMeasuresToBeSet = 0) or (AnalysisReportChartLine.Next() = 0); end; end; procedure SetDimensionChartTypesToDefault(var AnalysisReportChartLine: Record "Analysis Report Chart Line") begin AnalysisReportChartLine.Reset(); SetLinkToDimensionLines(AnalysisReportChartLine); AnalysisReportChartLine.SetRange("Chart Type", AnalysisReportChartLine."Chart Type"::" "); AnalysisReportChartLine.ModifyAll("Chart Type", AnalysisReportChartLine.GetDefaultChartType()); end; local procedure DeleteLines() var AnalysisReportChartLine: Record "Analysis Report Chart Line"; begin AnalysisReportChartLine.SetRange("User ID", "User ID"); AnalysisReportChartLine.SetRange("Analysis Area", "Analysis Area"); AnalysisReportChartLine.SetRange(Name, Name); AnalysisReportChartLine.DeleteAll(); end;}