Report 7112 Analysis Report

Base Application, Microsoft.Inventory.Analysis

src/Layers/W1/BaseApp/Inventory/Analysis/AnalysisReport.Report.al917 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 Microsoft.Finance.Analysis;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.Enums;using Microsoft.Foundation.Period;using System.Utilities;report 7112 "Analysis Report"{    Caption = 'Analysis Report';    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem(AnalysisLineTemplate; "Analysis Line Template")        {            DataItemTableView = sorting("Analysis Area", Name);            column(TempName_AnlysLine; Name)            {            }            dataitem(Heading; "Integer")            {                DataItemTableView = sorting(Number) where(Number = const(1));                column(TemplNameAnalysisColumn; AnalysisColumnTemplName)                {                }                column(TempName_Heading; AnalysisLineTemplate.Name)                {                }                column(FiscalStartDate; Format(FiscalStartDate))                {                }                column(PeriodText; PeriodText)                {                }                column(CompanyName; COMPANYPROPERTY.DisplayName())                {                }                column(TodayFormatted; Format(Today, 0, 4))                {                }                column(TempDesc_AnlysLine; AnalysisLineTemplate.Description)                {                }                column(ViewCode_ItemAnlys; ItemAnalysisView.Code)                {                }                column(ViewName_ItemAnlys; ItemAnalysisView.Name)                {                }                column(HeaderText; HeaderText)                {                }                column(NoOfRecords; NoOfRecords)                {                }                column(TblCptnAnalysisLineFilter; "Analysis Line".TableCaption + ': ' + AnalysisLineFilter)                {                }                column(AnalysisLineFilter; AnalysisLineFilter)                {                }                column(ReportSetup_ShowAnlys; ShowAnalysisReportSetup)                {                }                column(AnalysisColumnTemplNameCaption; AnalysisColumnTemplNameCaptionLbl)                {                }                column(AnalysisLineTemplateNameCaption; AnalysisLineTemplateNameCaptionLbl)                {                }                column(FiscalStartDateCaption; FiscalStartDateCaptionLbl)                {                }                column(PeriodTextCaption; PeriodTextCaptionLbl)                {                }                column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl)                {                }                column(AnalysisReportCaption; AnalysisReportCaptionLbl)                {                }                column(ItemAnalysisViewCodeCaption; ItemAnalysisViewCodeCaptionLbl)                {                }                dataitem(AnalysisLineSpec; "Analysis Line")                {                    DataItemLink = "Analysis Area" = field("Analysis Area"), "Analysis Line Template Name" = field(Name);                    DataItemLinkReference = AnalysisLineTemplate;                    DataItemTableView = sorting("Analysis Area", "Analysis Line Template Name", "Line No.");                    column(FormatUnderline; Format(Underline))                    {                    }                    column(FormatItalic; Format(Italic))                    {                    }                    column(FormatShowOpposite; Format("Show Opposite Sign"))                    {                    }                    column(FormatNewPage; Format("New Page"))                    {                    }                    column(FormatBold; Format(Bold))                    {                    }                    column(SpecShowOppSign_AnlysLine; "Show Opposite Sign")                    {                        IncludeCaption = true;                    }                    column(SpecUnderline__AnlysLine; Underline)                    {                        IncludeCaption = true;                    }                    column(SpecItalic_AnlysLine; Italic)                    {                        IncludeCaption = true;                    }                    column(SpecBold_AnlysLine; Bold)                    {                        IncludeCaption = true;                    }                    column(SpecShow_AnlysLine; Show)                    {                        IncludeCaption = true;                    }                    column(SpecNewPage_AnlysLine; "New Page")                    {                        IncludeCaption = true;                    }                    column(SpecDesc_AnlysLine; Description)                    {                        IncludeCaption = true;                    }                    column(SpecRowRefNo_AnlysLine; "Row Ref. No.")                    {                        IncludeCaption = true;                    }                    column(ViewDim1Code_ItemAnlys; ItemAnalysisView."Dimension 1 Code")                    {                    }                    column(SpecDim1Total_AnlysLine; "Dimension 1 Totaling")                    {                    }                    column(ASpecbody3View_AnlysLine; "Dimension 1 Totaling" <> '')                    {                    }                    column(ViewDim2Code_ItemAnlys; ItemAnalysisView."Dimension 2 Code")                    {                    }                    column(SpecDim2Total_AnlysLine; "Dimension 2 Totaling")                    {                    }                    column(Specbody4View_AnlysLine; "Dimension 2 Totaling" <> '')                    {                    }                    column(ViewDim3Code_ItemAnlys; ItemAnalysisView."Dimension 3 Code")                    {                    }                    column(SpecDim3Total_AnlysLine; "Dimension 3 Totaling")                    {                    }                    column(Specbody5View_AnlysLine; "Dimension 3 Totaling" <> '')                    {                    }                    column(SpecTmplName_AnlysLine; "Analysis Line Template Name")                    {                    }                    column(ItemAnalysisViewDimension1CodeCaption; ItemAnalysisViewDimension1CodeCaptionLbl)                    {                    }                    trigger OnPreDataItem()                    begin                        if not ShowAnalysisReportSetup then                            CurrReport.Break();                    end;                }                dataitem(PageBreak; "Integer")                {                    DataItemTableView = sorting(Number) where(Number = const(1));                    trigger OnAfterGetRecord()                    begin                        NoOfRecords := NoOfRecords + 1;                    end;                    trigger OnPreDataItem()                    begin                        if not ShowAnalysisReportSetup then                            CurrReport.Break();                    end;                }                dataitem("Analysis Line"; "Analysis Line")                {                    DataItemLink = "Analysis Area" = field("Analysis Area"), "Analysis Line Template Name" = field(Name);                    DataItemLinkReference = AnalysisLineTemplate;                    DataItemTableView = sorting("Analysis Area", "Analysis Line Template Name", "Line No.");                    column(Header1; Header[1])                    {                    }                    column(Header2; Header[2])                    {                    }                    column(Header3; Header[3])                    {                    }                    column(Header4; Header[4])                    {                    }                    column(Header5; Header[5])                    {                    }                    column(RoundingHeader5; RoundingHeader[5])                    {                        AutoCalcField = false;                    }                    column(RoundingHeader4; RoundingHeader[4])                    {                        AutoCalcField = false;                    }                    column(RoundingHeader3; RoundingHeader[3])                    {                        AutoCalcField = false;                    }                    column(RoundingHeader2; RoundingHeader[2])                    {                        AutoCalcField = false;                    }                    column(RoundingHeader1; RoundingHeader[1])                    {                        AutoCalcField = false;                    }                    column(Hdr2View_AnlysLine; HasRounding)                    {                    }                    column(Body8View_AnlysLine; (NoOfCols <= 1) and Underline)                    {                    }                    column(Body9View_AnlysLine; (NoOfCols = 2) and Underline)                    {                    }                    column(Body10View_AnlysLine; (NoOfCols = 3) and Underline)                    {                    }                    column(Body11View_AnlysLine; (NoOfCols = 4) and Underline)                    {                    }                    column(Body12View_AnlysLine; (NoOfCols = 5) and Underline)                    {                    }                    column(NewPage; "New Page")                    {                    }                    column(ColumnValuesAsText5; ColumnValuesAsText[5])                    {                        AutoCalcField = false;                    }                    column(ColumnValuesAsText4; ColumnValuesAsText[4])                    {                        AutoCalcField = false;                    }                    column(ColumnValuesAsText3; ColumnValuesAsText[3])                    {                        AutoCalcField = false;                    }                    column(ColumnValuesAsText2; ColumnValuesAsText[2])                    {                        AutoCalcField = false;                    }                    column(ColumnValuesAsText1; ColumnValuesAsText[1])                    {                        AutoCalcField = false;                    }                    column(Desc_AnlysLine; Description)                    {                        IncludeCaption = true;                    }                    column(RowRefNo_AnlysLine; "Row Ref. No.")                    {                    }                    column(RowRefNo_AnlysLineCaption; FieldCaption("Row Ref. No."))                    {                    }                    column(Body4View_AnlysLine; ShowLine(false, false))                    {                    }                    column(Body5View_AnlysLine; ShowLine(true, false))                    {                    }                    column(Body6View_AnlysLine; ShowLine(false, true))                    {                    }                    column(Body7View_AnlysLine; ShowLine(true, true))                    {                    }                    column(TemplateName_AnlysLine; "Analysis Line Template Name")                    {                    }                    trigger OnAfterGetRecord()                    begin                        for i := 1 to MaxColumnsDisplayed do begin                            ColumnValuesDisplayed[i] := 0;                            ColumnValuesAsText[i] := '';                        end;                        CalcColumns();                    end;                    trigger OnPreDataItem()                    begin                        SetFilter("Date Filter", DateFilter);                        SetFilter("Item Budget Filter", ItemBudgetFilter);                        SetFilter("Location Filter", LocationFilter);                        SetFilter("Dimension 1 Filter", Dim1Filter);                        SetFilter("Dimension 2 Filter", Dim2Filter);                        SetFilter("Dimension 3 Filter", Dim3Filter);                        if SourceTypeFilter <> SourceTypeFilter::" " then                            SetRange("Source Type Filter", SourceTypeFilter);                        SetFilter("Source No. Filter", SourceNoFilter);                    end;                }                trigger OnPreDataItem()                begin                    NoOfRecords := 0;                end;            }            trigger OnAfterGetRecord()            begin                GLSetup.Get();                if "Item Analysis View Code" <> '' then                    ItemAnalysisView.Get(AnalysisArea, "Item Analysis View Code")                else begin                    ItemAnalysisView.Init();                    ItemAnalysisView."Dimension 1 Code" := GLSetup."Global Dimension 1 Code";                    ItemAnalysisView."Dimension 2 Code" := GLSetup."Global Dimension 2 Code";                end;                if GLSetup."LCY Code" <> '' then                    HeaderText := StrSubstNo(Text003, GLSetup."LCY Code")                else                    HeaderText := '';            end;            trigger OnPreDataItem()            begin                SetRange("Analysis Area", AnalysisArea);                SetRange(Name, AnalysisLineTemplateName);            end;        }    }    requestpage    {        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    group("Layout")                    {                        Caption = 'Layout';                        field(AnalysisArea; AnalysisArea)                        {                            ApplicationArea = SalesAnalysis, PurchaseAnalysis, InventoryAnalysis;                            Caption = 'Analysis Area';                            ToolTip = 'Specifies if the analysis template is set up in the Sales, Purchasing, or Inventory application area.';                            trigger OnValidate()                            begin                                AnalysisReportName := '';                                AnalysisLineTemplateName := '';                                AnalysisColumnTemplName := '';                                Dim1Filter := '';                                Dim2Filter := '';                                Dim3Filter := '';                            end;                        }                        field(AnalysisReportName; AnalysisReportName)                        {                            ApplicationArea = SalesAnalysis, PurchaseAnalysis, InventoryAnalysis;                            Caption = 'Analysis Report Name';                            ToolTip = 'Specifies the report for which analysis figures are shown.';                            trigger OnLookup(var Text: Text): Boolean                            begin                                if AnalysisReportManagement.LookupAnalysisReportName(AnalysisArea, AnalysisReportName) then begin                                    Text := AnalysisReportName;                                    exit(true);                                end;                            end;                            trigger OnValidate()                            begin                                "Analysis Line".SetRange("Analysis Area", AnalysisArea);                                AnalysisReportManagement.CheckReportName(AnalysisReportName, "Analysis Line");                                if AnalysisReportNameRec.Get(AnalysisArea, AnalysisReportName) then begin                                    if AnalysisReportNameRec."Analysis Line Template Name" <> '' then                                        AnalysisLineTemplateName := AnalysisReportNameRec."Analysis Line Template Name";                                    if AnalysisReportNameRec."Analysis Column Template Name" <> '' then                                        AnalysisColumnTemplName := AnalysisReportNameRec."Analysis Column Template Name";                                end;                                ValidateAnalysisLineTemplate();                            end;                        }                        field(AnalysisLineName; AnalysisLineTemplateName)                        {                            ApplicationArea = SalesAnalysis, PurchaseAnalysis, InventoryAnalysis;                            Caption = 'Analysis Line Name';                            ToolTip = 'Specifies the line for which analysis figures are shown.';                            trigger OnLookup(var Text: Text): Boolean                            var                                TmpAnalysisLineTemplate: Record "Analysis Line Template";                            begin                                TmpAnalysisLineTemplate.FilterGroup := 2;                                TmpAnalysisLineTemplate.SetRange("Analysis Area", AnalysisArea);                                TmpAnalysisLineTemplate.FilterGroup := 0;                                if PAGE.RunModal(0, TmpAnalysisLineTemplate) = ACTION::LookupOK then begin                                    Text := TmpAnalysisLineTemplate.Name;                                    exit(true);                                end;                            end;                            trigger OnValidate()                            begin                                "Analysis Line".SetRange("Analysis Area", AnalysisArea);                                AnalysisReportManagement.CheckAnalysisLineTemplName(AnalysisLineTemplateName, "Analysis Line");                                ValidateAnalysisLineTemplate();                            end;                        }                        field(AnalysisColumnName; AnalysisColumnTemplName)                        {                            ApplicationArea = SalesAnalysis, PurchaseAnalysis, InventoryAnalysis;                            Caption = 'Analysis Column Name';                            ToolTip = 'Specifies the column for which analysis figures are shown.';                            trigger OnLookup(var Text: Text): Boolean                            begin                                AnalysisReportManagement.LookupAnalysisColumnName(AnalysisArea, AnalysisColumnTemplName);                            end;                            trigger OnValidate()                            begin                                AnalysisReportManagement.GetColumnTemplate(AnalysisArea.AsInteger(), AnalysisColumnTemplName);                            end;                        }                    }                    group(Filters)                    {                        Caption = 'Filters';                        field(DateFilter; DateFilter)                        {                            ApplicationArea = SalesAnalysis, PurchaseAnalysis, InventoryAnalysis;                            Caption = 'Date Filter';                            ToolTip = 'Specifies the period for which the analysis report will show figures based on item ledger entries, value entries, and analysis view entries.';                            trigger OnValidate()                            begin                                "Analysis Line".SetFilter("Date Filter", DateFilter);                                DateFilter := "Analysis Line".GetFilter("Date Filter");                            end;                        }                        field(ItemBudgetFilter; ItemBudgetFilter)                        {                            ApplicationArea = ItemBudget;                            Caption = 'Item Budget Filter';                            ToolTip = 'Specifies the item budget(s) for which analysis figures are shown.';                            trigger OnLookup(var Text: Text): Boolean                            var                                ItemBudgetName: Record "Item Budget Name";                            begin                                ItemBudgetName.SetRange("Analysis Area", AnalysisArea);                                if PAGE.RunModal(0, ItemBudgetName) = ACTION::LookupOK then begin                                    Text := ItemBudgetName.Name;                                    exit(true);                                end;                            end;                            trigger OnValidate()                            begin                                "Analysis Line".SetFilter("Item Budget Filter", ItemBudgetFilter);                                ItemBudgetFilter := "Analysis Line".GetFilter("Item Budget Filter");                            end;                        }                        field(SourceTypeFilter; SourceTypeFilter)                        {                            ApplicationArea = SalesAnalysis, PurchaseAnalysis, InventoryAnalysis;                            Caption = 'Source Type Filter';                            ToolTip = 'Specifies if figures in the analysis report are filtered by item number, customer number, or vendor number.';                            trigger OnValidate()                            begin                                SourceNoFilter := '';                            end;                        }                        field(SourceNoFilter; SourceNoFilter)                        {                            ApplicationArea = SalesAnalysis, PurchaseAnalysis, InventoryAnalysis;                            Caption = 'Source No. Filter';                            ToolTip = 'Specifies the item, customer, or vendor numbers that figures in the analysis report are filtered by.';                            trigger OnLookup(var Text: Text): Boolean                            begin                                AnalysisReportManagement.DoLookupSourceNo("Analysis Line", SourceTypeFilter, SourceNoFilter);                            end;                        }                    }                    group("Dimension Filters")                    {                        Caption = 'Dimension Filters';                        field(Dim1Filter; Dim1Filter)                        {                            ApplicationArea = Dimensions;                            CaptionClass = FormGetCaptionClass(1);                            Caption = 'Dimension 1 Filter';                            Enabled = Dim1FilterEnable;                            ToolTip = 'Specifies a filter for dimension values within a dimension. The filter uses the dimension you have defined as dimension 1 for the analysis view selected in the Analysis View Code field.';                            trigger OnLookup(var Text: Text): Boolean                            begin                                exit(FormLookUpDimFilter(ItemAnalysisView."Dimension 1 Code", Text));                            end;                        }                        field(Dim2Filter; Dim2Filter)                        {                            ApplicationArea = Dimensions;                            CaptionClass = FormGetCaptionClass(2);                            Caption = 'Dimension 2 Filter';                            Enabled = Dim2FilterEnable;                            ToolTip = 'Specifies a filter for dimension values within a dimension. The filter uses the dimension you have defined as dimension 2 for the analysis view selected in the Analysis View Code field.';                            trigger OnLookup(var Text: Text): Boolean                            begin                                exit(FormLookUpDimFilter(ItemAnalysisView."Dimension 2 Code", Text));                            end;                        }                        field(Dim3Filter; Dim3Filter)                        {                            ApplicationArea = Dimensions;                            CaptionClass = FormGetCaptionClass(3);                            Caption = 'Dimension 3 Filter';                            Enabled = Dim3FilterEnable;                            ToolTip = 'Specifies a filter for dimension values within a dimension. The filter uses the dimension you have defined as dimension 3 for the analysis view selected in the Analysis View Code field.';                            trigger OnLookup(var Text: Text): Boolean                            begin                                exit(FormLookUpDimFilter(ItemAnalysisView."Dimension 3 Code", Text));                            end;                        }                    }                    group(Show)                    {                        Caption = 'Show';                        field(ShowError; ShowError)                        {                            ApplicationArea = SalesAnalysis, PurchaseAnalysis, InventoryAnalysis;                            Caption = 'Show Error';                            OptionCaption = 'None,Division by Zero,Period Error,Both';                            ToolTip = 'Specifies if the report shows error information.';                        }                        field(ShowAnalysisReportSetup; ShowAnalysisReportSetup)                        {                            ApplicationArea = SalesAnalysis, PurchaseAnalysis, InventoryAnalysis;                            Caption = 'Show Analysis Report Setup';                            MultiLine = true;                            ToolTip = 'Specifies if the actual report with the amounts will be preceded by one or more pages that describe the analysis report setup. That is, the first pages of the report show the lines that have been defined in the Analysis Report window.';                        }                    }                }            }        }        actions        {        }        trigger OnInit()        begin            Dim3FilterEnable := true;            Dim2FilterEnable := true;            Dim1FilterEnable := true;        end;        trigger OnOpenPage()        begin            GLSetup.Get();            if UseHiddenFilters then begin                AnalysisArea := AnalysisAreaHidden;                AnalysisReportName := AnalysisReportNameHidden;                AnalysisLineTemplateName := AnalysisLineTemplateNameHidden;                AnalysisColumnTemplName := AnalysisColumnTemplNameHidden;            end;            if AnalysisLineTemplateName <> '' then                if not AnalysisLineTemplate.Get(AnalysisArea, AnalysisLineTemplateName) then                    AnalysisLineTemplateName := '';            if AnalysisLineTemplateName = '' then begin                AnalysisLineTemplate.SetRange("Analysis Area", AnalysisArea);                if AnalysisLineTemplate.Find('-') then                    AnalysisLineTemplateName := AnalysisLineTemplate.Name;            end;            if AnalysisLineTemplate."Item Analysis View Code" <> '' then                ItemAnalysisView.Get(AnalysisArea, AnalysisLineTemplate."Item Analysis View Code")            else begin                ItemAnalysisView."Dimension 1 Code" := GLSetup."Global Dimension 1 Code";                ItemAnalysisView."Dimension 2 Code" := GLSetup."Global Dimension 2 Code";            end;            Dim1FilterEnable := ItemAnalysisView."Dimension 1 Code" <> '';            Dim2FilterEnable := ItemAnalysisView."Dimension 2 Code" <> '';            Dim3FilterEnable := ItemAnalysisView."Dimension 3 Code" <> '';            if UseHiddenFilters then begin                DateFilter := DateFilterHidden;                ItemBudgetFilter := ItemBudgetFilterHidden;                LocationFilter := LocationFilterHidden;                Dim1Filter := Dim1FilterHidden;                Dim2Filter := Dim2FilterHidden;                Dim3Filter := Dim3FilterHidden;                SourceTypeFilter := SourceTypeFilterHidden;                SourceNoFilter := SourceNoFilterHidden;            end;        end;    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Inventory/Analysis/AnalysisReport.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        InitAnalysisLine();    end;    var        TempAnalysisColumn: Record "Analysis Column" temporary;        AnalysisReportNameRec: Record "Analysis Report Name";        ItemAnalysisView: Record "Item Analysis View";        GLSetup: Record "General Ledger Setup";        AnalysisReportManagement: Codeunit "Analysis Report Management";        AccountingPeriodMgt: Codeunit "Accounting Period Mgt.";        MatrixMgt: Codeunit "Matrix Management";        AnalysisArea: Enum "Analysis Area Type";        AnalysisAreaHidden: Enum "Analysis Area Type";        AnalysisReportName: Code[10];        AnalysisReportNameHidden: Code[10];        AnalysisLineTemplateName: Code[10];        AnalysisLineTemplateNameHidden: Code[10];        AnalysisColumnTemplName: Code[10];        AnalysisColumnTemplNameHidden: Code[10];        SourceTypeFilter: Enum "Analysis Source Type";        SourceTypeFilterHidden: Enum "Analysis Source Type";        SourceNoFilter: Text;        SourceNoFilterHidden: Text;        EndDate: Date;        ShowError: Option "None","Division by Zero","Period Error",Both;        DateFilter: Text;        UseHiddenFilters: Boolean;        DateFilterHidden: Text;        ItemBudgetFilter: Text;        ItemBudgetFilterHidden: Text;        LocationFilter: Text;        LocationFilterHidden: Text;        Dim1Filter: Text;        Dim1FilterHidden: Text;        Dim2Filter: Text;        Dim2FilterHidden: Text;        Dim3Filter: Text;        Dim3FilterHidden: Text;        FiscalStartDate: Date;        ColumnValuesDisplayed: array[5] of Decimal;        ColumnValuesAsText: array[5] of Text[30];        PeriodText: Text;        AnalysisLineFilter: Text;        Header: array[5] of Text[50];        RoundingHeader: array[5] of Text[30];        HasRounding: Boolean;        i: Integer;        MaxColumnsDisplayed: Integer;        NoOfCols: Integer;        ShowAnalysisReportSetup: Boolean;        HeaderText: Text[100];        NoOfRecords: Integer;        Dim1FilterEnable: Boolean;        Dim2FilterEnable: Boolean;        Dim3FilterEnable: Boolean;#pragma warning disable AA0074        Text000: Label '(Thousands)';        Text001: Label '(Millions)';        Text002: Label '* ERROR *';#pragma warning disable AA0470        Text003: Label 'All amounts are in %1.';#pragma warning restore AA0470        Text004: Label 'Not Available';#pragma warning disable AA0470        Text005: Label '1,6,,Dimension %1 Filter';#pragma warning restore AA0470#pragma warning restore AA0074        AnalysisColumnTemplNameCaptionLbl: Label 'Analysis Column';        AnalysisLineTemplateNameCaptionLbl: Label 'Analysis Line';        FiscalStartDateCaptionLbl: Label 'Fiscal Start Date';        PeriodTextCaptionLbl: Label 'Period';        CurrReportPageNoCaptionLbl: Label 'Page';        AnalysisReportCaptionLbl: Label 'Analysis Report';        ItemAnalysisViewCodeCaptionLbl: Label 'Analysis View';        ItemAnalysisViewDimension1CodeCaptionLbl: Label 'Dimension Code';    procedure InitAnalysisLine()    begin        AnalysisLineTemplate.SetRange("Analysis Area", AnalysisArea);        AnalysisLineTemplate.SetRange(Name, AnalysisLineTemplateName);        "Analysis Line".FilterGroup := 2;        "Analysis Line".SetRange("Analysis Area", AnalysisArea);        "Analysis Line".FilterGroup := 0;        "Analysis Line".SetFilter(Show, '<>%1', "Analysis Line".Show::No);        "Analysis Line".SetFilter("Date Filter", DateFilter);        "Analysis Line".SetFilter("Item Budget Filter", ItemBudgetFilter);        "Analysis Line".SetFilter("Location Filter", LocationFilter);        "Analysis Line".SetFilter("Dimension 1 Filter", Dim1Filter);        "Analysis Line".SetFilter("Dimension 2 Filter", Dim2Filter);        "Analysis Line".SetFilter("Dimension 3 Filter", Dim3Filter);        if SourceTypeFilter <> SourceTypeFilter::" " then            "Analysis Line".SetRange("Source Type Filter", SourceTypeFilter);        "Analysis Line".SetFilter("Source No. Filter", SourceNoFilter);        EndDate := "Analysis Line".GetRangeMax("Date Filter");        FiscalStartDate := AccountingPeriodMgt.FindFiscalYear(EndDate);        MaxColumnsDisplayed := ArrayLen(ColumnValuesDisplayed);        AnalysisLineFilter := "Analysis Line".GetFilters();        PeriodText := "Analysis Line".GetFilter("Date Filter");        HasRounding := false;        NoOfCols := 0;        AnalysisReportManagement.CopyColumnsToTemp("Analysis Line", AnalysisColumnTemplName, TempAnalysisColumn);        i := 0;        if TempAnalysisColumn.Find('-') then begin            repeat                if TempAnalysisColumn.Show <> TempAnalysisColumn.Show::Never then begin                    i := i + 1;                    if i <= MaxColumnsDisplayed then begin                        Header[i] := TempAnalysisColumn."Column Header";                        RoundingHeader[i] := '';                        if TempAnalysisColumn."Rounding Factor" in [TempAnalysisColumn."Rounding Factor"::"1000", TempAnalysisColumn."Rounding Factor"::"1000000"] then begin                            HasRounding := true;                            case TempAnalysisColumn."Rounding Factor" of                                TempAnalysisColumn."Rounding Factor"::"1000":                                    RoundingHeader[i] := Text000;                                TempAnalysisColumn."Rounding Factor"::"1000000":                                    RoundingHeader[i] := Text001;                            end;                        end;                    end;                    NoOfCols += 1;                end;            until (i >= MaxColumnsDisplayed) or (TempAnalysisColumn.Next() = 0);            MaxColumnsDisplayed := i;        end;    end;    procedure SetParameters(NewAnalysisArea: Enum "Analysis Area Type"; NewReportName: Code[10]; NewLineTemplateName: Code[10]; NewColumnTemplateName: Code[10])    begin        UseHiddenFilters := true;        AnalysisAreaHidden := NewAnalysisArea;        AnalysisReportNameHidden := NewReportName;        AnalysisLineTemplateNameHidden := NewLineTemplateName;        AnalysisColumnTemplNameHidden := NewColumnTemplateName;    end;    procedure SetFilters(NewDateFilter: Text; NewItemBudgetFilter: Text; NewLocationFilter: Text; NewDim1Filter: Text; NewDim2Filter: Text; NewDim3Filter: Text; NewSourceTypeFilter: Option " ",Customer,Vendor,Item; NewSourceNoFilter: Text)    begin        DateFilterHidden := NewDateFilter;        ItemBudgetFilterHidden := NewItemBudgetFilter;        LocationFilterHidden := NewLocationFilter;        Dim1FilterHidden := NewDim1Filter;        Dim2FilterHidden := NewDim2Filter;        Dim3FilterHidden := NewDim3Filter;        SourceTypeFilterHidden := Enum::"Analysis Source Type".FromInteger(NewSourceTypeFilter);        SourceNoFilterHidden := NewSourceNoFilter;    end;    local procedure CalcColumns(): Boolean    var        NonZero: Boolean;    begin        NonZero := false;        TempAnalysisColumn.SetRange(TempAnalysisColumn."Analysis Column Template", AnalysisColumnTemplName);        i := 0;        if TempAnalysisColumn.Find('-') then            repeat                if TempAnalysisColumn.Show <> TempAnalysisColumn.Show::Never then begin                    i := i + 1;                    ColumnValuesDisplayed[i] :=                      AnalysisReportManagement.CalcCell("Analysis Line", TempAnalysisColumn, false);                    if AnalysisReportManagement.GetDivisionError() then                        if ShowError in [ShowError::"Division by Zero", ShowError::Both] then                            ColumnValuesAsText[i] := Text002                        else                            ColumnValuesAsText[i] := ''                    else                        if AnalysisReportManagement.GetPeriodError() then                            if ShowError in [ShowError::"Period Error", ShowError::Both] then                                ColumnValuesAsText[i] := Text004                            else                                ColumnValuesAsText[i] := ''                        else begin                            NonZero := NonZero or (ColumnValuesDisplayed[i] <> 0);                            ColumnValuesAsText[i] :=                              MatrixMgt.FormatAmount(ColumnValuesDisplayed[i], TempAnalysisColumn."Rounding Factor", false);                        end;                end;            until (i >= MaxColumnsDisplayed) or (TempAnalysisColumn.Next() = 0);        exit(NonZero);    end;    local procedure ShowLine(Bold: Boolean; Italic: Boolean): Boolean    var        NonZero: Boolean;    begin        if "Analysis Line".Show = "Analysis Line".Show::No then            exit(false);        if "Analysis Line".Bold <> Bold then            exit(false);        if "Analysis Line".Italic <> Italic then            exit(false);        NonZero := CalcColumns();        if "Analysis Line".Show = "Analysis Line".Show::"If Any Column Not Zero" then            exit(NonZero);        exit(true);    end;    local procedure ValidateAnalysisLineTemplate()    begin        if AnalysisLineTemplate.Get(AnalysisArea, AnalysisLineTemplateName) then begin            if AnalysisLineTemplate."Default Column Template Name" <> '' then                AnalysisColumnTemplName := AnalysisLineTemplate."Default Column Template Name";            if AnalysisLineTemplate."Item Analysis View Code" <> '' then                ItemAnalysisView.Get(AnalysisArea, AnalysisLineTemplate."Item Analysis View Code")            else begin                Clear(ItemAnalysisView);                ItemAnalysisView."Dimension 1 Code" := GLSetup."Global Dimension 1 Code";                ItemAnalysisView."Dimension 2 Code" := GLSetup."Global Dimension 2 Code";            end;        end;    end;    local procedure FormLookUpDimFilter(Dim: Code[20]; var Text: Text): Boolean    var        DimVal: Record "Dimension Value";        DimValList: Page "Dimension Value List";    begin        if Dim = '' then            exit(false);        DimValList.LookupMode(true);        DimVal.SetRange("Dimension Code", Dim);        DimValList.SetTableView(DimVal);        if DimValList.RunModal() = ACTION::LookupOK then begin            DimValList.GetRecord(DimVal);            Text := DimValList.GetSelectionFilter();            exit(true);        end;        exit(false);    end;    local procedure FormGetCaptionClass(DimNo: Integer): Text[250]    begin        case DimNo of            1:                begin                    if ItemAnalysisView."Dimension 1 Code" <> '' then                        exit('1,6,' + ItemAnalysisView."Dimension 1 Code");                    exit(StrSubstNo(Text005, DimNo));                end;            2:                begin                    if ItemAnalysisView."Dimension 2 Code" <> '' then                        exit('1,6,' + ItemAnalysisView."Dimension 2 Code");                    exit(StrSubstNo(Text005, DimNo));                end;            3:                begin                    if ItemAnalysisView."Dimension 3 Code" <> '' then                        exit('1,6,' + ItemAnalysisView."Dimension 3 Code");                    exit(StrSubstNo(Text005, DimNo));                end;        end;    end;}