Report 7112 Analysis Report
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;}