Report 5065 Segment - Labels

Base Application, Microsoft.CRM.Reports

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;}