Report 5065 Segment - Labels, source in 29

Source29

src/Layers/W1/BaseApp/CRM/Reports/SegmentLabels.Report.al233 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.CRM.Reports;

using Microsoft.CRM.Contact;
using Microsoft.CRM.Segment;
using Microsoft.Foundation.Address;

report 5065 "Segment - Labels"
{
    Caption = 'Segment - Labels';
    DefaultRenderingLayout = RDLCLayout;

    dataset
    {
        dataitem("Segment Header"; "Segment Header")
        {
            DataItemTableView = sorting("No.");
            dataitem("Segment Line"; "Segment Line")
            {
                DataItemLink = "Segment No." = field("No.");
                DataItemTableView = sorting("Segment No.", "Line No.");
                column(ContAddr11; ContAddr[1] [1])
                {
                }
                column(ContAddr12; ContAddr[1] [2])
                {
                }
                column(ContAddr13; ContAddr[1] [3])
                {
                }
                column(ContAddr14; ContAddr[1] [4])
                {
                }
                column(ContAddr15; ContAddr[1] [5])
                {
                }
                column(ContAddr16; ContAddr[1] [6])
                {
                }
                column(ContAddr21; ContAddr[2] [1])
                {
                }
                column(ContAddr22; ContAddr[2] [2])
                {
                }
                column(ContAddr23; ContAddr[2] [3])
                {
                }
                column(ContAddr24; ContAddr[2] [4])
                {
                }
                column(ContAddr25; ContAddr[2] [5])
                {
                }
                column(ContAddr26; ContAddr[2] [6])
                {
                }
                column(ContAddr31; ContAddr[3] [1])
                {
                }
                column(ContAddr32; ContAddr[3] [2])
                {
                }
                column(ContAddr33; ContAddr[3] [3])
                {
                }
                column(ContAddr34; ContAddr[3] [4])
                {
                }
                column(ContAddr35; ContAddr[3] [5])
                {
                }
                column(ContAddr36; ContAddr[3] [6])
                {
                }
                column(ContAddr17; ContAddr[1] [7])
                {
                }
                column(ContAddr18; ContAddr[1] [8])
                {
                }
                column(ContAddr27; ContAddr[2] [7])
                {
                }
                column(ContAddr28; ContAddr[2] [8])
                {
                }
                column(ContAddr37; ContAddr[3] [7])
                {
                }
                column(ContAddr38; ContAddr[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
                    Cont.Get("Contact No.");

                    RecordNo := RecordNo + 1;
                    ColumnNo := ColumnNo + 1;

                    FormatAddr.ContactAddrAlt(ContAddr[ColumnNo], Cont, "Contact Alt. Address Code", Date);

                    if RecordNo = NoOfRecords then begin
                        for i := ColumnNo + 1 to NoOfColumns do
                            Clear(ContAddr[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;

                    RecordNo := 0;
                end;
            }

            trigger OnAfterGetRecord()
            begin
                NoOfRecords := 0;
                SegLine.SetFilter("Segment No.", "No.");
                NoOfRecords := SegLine.Count();
            end;
        }
    }

    requestpage
    {
        AboutTitle = 'About Segment - Labels';
        AboutText = 'Print labels with the names and addresses of contacts for your segments.';
        SaveValues = true;

        layout
        {
            area(content)
            {
                group(Options)
                {
                    Caption = 'Options';
                    field(LabelFormat; LabelFormat)
                    {
                        ApplicationArea = RelationshipMgmt;
                        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 = './CRM/Reports/SegmentLabels.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 := 8;
    end;

    var
        SegLine: Record "Segment Line";
        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)";
        NoOfRecords: Integer;
        RecordNo: Integer;
        NoOfColumns: Integer;
        i: Integer;
        GroupNo: Integer;
        Counter: Integer;
        RecPerPageNum: Integer;

    protected var
        Cont: Record Contact;
        ContAddr: array[3, 8] of Text[100];
        ColumnNo: Integer;

    procedure InitializeRequest(LabelFormatFrom: Option)
    begin
        LabelFormat := LabelFormatFrom;
    end;
}