Report 110 Customer - Labels

Base Application, Microsoft.Sales.Reports

src/Layers/W1/BaseApp/Sales/Reports/CustomerLabels.Report.al221 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.Sales.Reports;/// <summary>/// Prints mailing labels for customers using their address information in a multi-column format./// </summary>using Microsoft.Foundation.Address;using Microsoft.Sales.Customer;report 110 "Customer - Labels"{    ApplicationArea = Suite;    Caption = 'Customer - Labels';    ToolTip = 'View, save, or print mailing labels with the customers'' names and addresses. The report can be used to send sales letters, for example.';    UsageCategory = ReportsAndAnalysis;    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem(Customer; Customer)        {            RequestFilterFields = "No.", Name;            column(CustAddr_1__1_; CustAddr[1] [1])            {            }            column(CustAddr_1__2_; CustAddr[1] [2])            {            }            column(CustAddr_1__3_; CustAddr[1] [3])            {            }            column(CustAddr_1__4_; CustAddr[1] [4])            {            }            column(CustAddr_1__5_; CustAddr[1] [5])            {            }            column(CustAddr_1__6_; CustAddr[1] [6])            {            }            column(CustAddr_2__1_; CustAddr[2] [1])            {            }            column(CustAddr_2__2_; CustAddr[2] [2])            {            }            column(CustAddr_2__3_; CustAddr[2] [3])            {            }            column(CustAddr_2__4_; CustAddr[2] [4])            {            }            column(CustAddr_2__5_; CustAddr[2] [5])            {            }            column(CustAddr_2__6_; CustAddr[2] [6])            {            }            column(CustAddr_3__1_; CustAddr[3] [1])            {            }            column(CustAddr_3__2_; CustAddr[3] [2])            {            }            column(CustAddr_3__3_; CustAddr[3] [3])            {            }            column(CustAddr_3__4_; CustAddr[3] [4])            {            }            column(CustAddr_3__5_; CustAddr[3] [5])            {            }            column(CustAddr_3__6_; CustAddr[3] [6])            {            }            column(CustAddr_1__7_; CustAddr[1] [7])            {            }            column(CustAddr_1__8_; CustAddr[1] [8])            {            }            column(CustAddr_2__7_; CustAddr[2] [7])            {            }            column(CustAddr_2__8_; CustAddr[2] [8])            {            }            column(CustAddr_3__7_; CustAddr[3] [7])            {            }            column(CustAddr_3__8_; CustAddr[3] [8])            {            }            column(ShowBody1; (ColumnNo = 0) and (LabelFormat = LabelFormat::"36 x 70 mm (3 columns)"))            {            }            column(GroupNo1; GroupNo)            {            }            column(ShowBody2; (ColumnNo = 0) and (LabelFormat = LabelFormat::"37 x 70 mm (3 columns)"))            {            }            column(ShowBody3; (ColumnNo = 0) and (LabelFormat = LabelFormat::"36 x 105 mm (2 columns)"))            {            }            column(ShowBody4; (ColumnNo = 0) and (LabelFormat = LabelFormat::"37 x 105 mm (2 columns)"))            {            }            trigger OnAfterGetRecord()            begin                RecordNo := RecordNo + 1;                ColumnNo := ColumnNo + 1;                FormatAddr.Customer(CustAddr[ColumnNo], Customer);                if RecordNo = NoOfRecords then begin                    for i := ColumnNo + 1 to NoOfColumns do                        Clear(CustAddr[i]);                    ColumnNo := 0;                end else                    if ColumnNo = NoOfColumns then                        ColumnNo := 0;                if ColumnNo = 0 then begin                    if Counter = RecPerPageNum then begin                        GroupNo := GroupNo + 1;                        Counter := 0;                    end;                    Counter := Counter + 1;                end;            end;            trigger OnPreDataItem()            begin                case LabelFormat of                    LabelFormat::"36 x 70 mm (3 columns)", LabelFormat::"37 x 70 mm (3 columns)":                        NoOfColumns := 3;                    LabelFormat::"36 x 105 mm (2 columns)", LabelFormat::"37 x 105 mm (2 columns)":                        NoOfColumns := 2;                end;                NoOfRecords := Count;                RecordNo := 0;            end;        }    }    requestpage    {        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(LabelFormat; LabelFormat)                    {                        ApplicationArea = Suite;                        Caption = 'Format';                        OptionCaption = '36 x 70 mm (3 columns),37 x 70 mm (3 columns),36 x 105 mm (2 columns),37 x 105 mm (2 columns)';                        ToolTip = 'Specifies the format of the label.';                    }                }            }        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Sales/Reports/CustomerLabels.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        GroupNo := 1;        RecPerPageNum := 7;    end;    var        FormatAddr: Codeunit "Format Address";        LabelFormat: Option "36 x 70 mm (3 columns)","37 x 70 mm (3 columns)","36 x 105 mm (2 columns)","37 x 105 mm (2 columns)";        CustAddr: array[3, 8] of Text[100];        NoOfRecords: Integer;        RecordNo: Integer;        NoOfColumns: Integer;        ColumnNo: Integer;        i: Integer;        GroupNo: Integer;        Counter: Integer;        RecPerPageNum: Integer;    /// <summary>    /// Initializes the report request options for the Customer Labels report.    /// </summary>    /// <param name="SetLabelFormat">The label format option to use for printing.</param>    procedure InitializeRequest(SetLabelFormat: Option)    begin        LabelFormat := SetLabelFormat;    end;}