Report 21 No. Series in 25

App
Business Foundation
Namespace
Microsoft.Foundation.NoSeries
Obsolete
Pending 24.0. Report data is available on page 457 "No. Series Lines". It can be analyzed with either the Data Analysis feature or Open in Excel.

Versions171819202122232425262728latest

Source242526

Source in 25

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