Report 21 No. Series

Business Foundation, Microsoft.Foundation.NoSeries

src/Business Foundation/App/NoSeries/src/Legacy/NoSeries.Report.al193 lines, Copyright (c) Microsoft Corporation. MIT

#if not CLEAN24// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Foundation.NoSeries;using System.Utilities;report 21 "No. Series"{    Caption = 'No. Series';    DefaultRenderingLayout = LayoutRdlc;    ObsoleteState = Pending;    ObsoleteTag = '24.0';    ObsoleteReason = 'Report data is available on page 457 "No. Series Lines". It can be analyzed with either the Data Analysis feature or Open in Excel.';    dataset    {        dataitem("No. Series"; "No. Series")        {            RequestFilterFields = "Code";            column(COMPANYNAME; CompanyProperty.DisplayName())            {            }            column(No__Series__TABLECAPTION__________NoSeriesFilter; TableCaption + ': ' + NoSeriesFilter)            {            }            column(No__Series_Line__TABLECAPTION__________NoSeriesLineFilter; "No. Series Line".TableCaption + ': ' + NoSeriesLineFilter)            {            }            column(No__Series_Code; Code)            {            }            column(No__Series_Description; Description)            {            }            column(No__Series__Default_Nos__; Format("Default Nos."))            {            }            column(No__Series__Manual_Nos__; Format("Manual Nos."))            {            }            column(No__Series__Date_Order_; Format("Date Order"))            {            }            column(No__SeriesCaption; No__SeriesCaptionLbl)            {            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {            }            column(No__Series_Line_OpenCaption; No__Series_Line_OpenCaptionLbl)            {            }            column(No__Series_Line__Increment_by_No__Caption; "No. Series Line".FieldCaption("Increment-by No."))            {            }            column(No__Series_Line__Warning_No__Caption; "No. Series Line".FieldCaption("Warning No."))            {            }            column(No__Series_Line__Last_No__Used_Caption; "No. Series Line".FieldCaption("Last No. Used"))            {            }            column(No__Series_Line__Ending_No__Caption; "No. Series Line".FieldCaption("Ending No."))            {            }            column(No__Series_Line__Starting_No__Caption; "No. Series Line".FieldCaption("Starting No."))            {            }            column(No__Series_Line__Starting_Date_Caption; No__Series_Line__Starting_Date_CaptionLbl)            {            }            column(No__Series__Default_Nos__Caption; No__Series__Default_Nos__CaptionLbl)            {            }            column(No__Series__Manual_Nos__Caption; No__Series__Manual_Nos__CaptionLbl)            {            }            column(No__Series__Date_Order_Caption; No__Series__Date_Order_CaptionLbl)            {            }            dataitem("No. Series Line"; "No. Series Line")            {                DataItemLink = "Series Code" = field(Code);                DataItemTableView = sorting("Series Code");                RequestFilterFields = "Starting Date";                column(No__Series_Line__Starting_Date_; Format("Starting Date"))                {                }                column(No__Series_Line__Starting_No__; "Starting No.")                {                }                column(No__Series_Line__Ending_No__; "Ending No.")                {                }                column(No__Series_Line__Last_No__Used_; "Last No. Used")                {                }                column(No__Series_Line_Open; Format(Open))                {                }                column(No__Series_Line__Warning_No__; "Warning No.")                {                }                column(No__Series_Line__Increment_by_No__; "Increment-by No.")                {                }                column(No__Series_Line_Series_Code; "Series Code")                {                }            }            dataitem("No. Series Relationship"; "No. Series Relationship")            {                DataItemLink = Code = field(Code);                DataItemTableView = sorting(Code);                column(No__Series_Relationship__Series_Code_; "Series Code")                {                }                column(No__Series_Relationship__Series_Description_; "Series Description")                {                }                column(No__Series_Relationship_Code; Code)                {                }                column(Related_No__SeriesCaption; Related_No__SeriesCaptionLbl)                {                }                dataitem(NoSeriesLine2; "No. Series Line")                {                    DataItemLink = "Series Code" = field("Series Code");                    DataItemTableView = sorting("Series Code");                    column(NoSeriesLine2__Starting_Date_; Format("Starting Date"))                    {                    }                    column(NoSeriesLine2__Starting_No__; "Starting No.")                    {                    }                    column(NoSeriesLine2__Ending_No__; "Ending No.")                    {                    }                    column(NoSeriesLine2__Last_No__Used_; "Last No. Used")                    {                    }                    column(NoSeriesLine2__Warning_No__; "Warning No.")                    {                    }                    column(NoSeriesLine2__Increment_by_No__; "Increment-by No.")                    {                    }                    column(NoSeriesLine2_Open; Format(Open))                    {                    }                    column(NoSeriesLine2_Series_Code; "Series Code")                    {                    }                }            }            dataitem(BlankLoop; Integer)            {                DataItemTableView = sorting(Number) where(Number = const(1));            }        }    }    rendering    {        layout(LayoutRdlc)        {            Type = RDLC;            LayoutFile = './NoSeries/src/Legacy/NoSeries.rdlc';        }    }    trigger OnPreReport()    begin        NoSeriesFilter := "No. Series".GetFilters();        NoSeriesLineFilter := "No. Series Line".GetFilters();    end;    var        NoSeriesFilter: Text;        NoSeriesLineFilter: Text;        No__SeriesCaptionLbl: Label 'No. Series';        CurrReport_PAGENOCaptionLbl: Label 'Page';        No__Series_Line_OpenCaptionLbl: Label 'Open';        No__Series_Line__Starting_Date_CaptionLbl: Label 'Starting Date';        No__Series__Default_Nos__CaptionLbl: Label 'Default Nos.';        No__Series__Manual_Nos__CaptionLbl: Label 'Manual Nos.';        No__Series__Date_Order_CaptionLbl: Label 'Date Order';        Related_No__SeriesCaptionLbl: Label 'Related No. Series';}#endif