Report 5050 Contact - List
src/Layers/W1/BaseApp/CRM/Reports/ContactList.Report.al176 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.Foundation.Address;report 5050 "Contact - List"{ ApplicationArea = Basic, Suite; Caption = 'Contact List'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem(Contact; Contact) { RequestFilterFields = "No.", "Search Name", Type, "Salesperson Code", "Post Code", "Country/Region Code"; column(COMPANYNAME; COMPANYPROPERTY.DisplayName()) { } column(FORMAT_TODAY_0_4_; Format(Today, 0, 4)) { } column(Contact_TABLECAPTION__________ContactFilter; TableCaption + ': ' + ContactFilter) { } column(ShowContactFilter; ContactFilter) { } column(Contact__No__; "No.") { } column(Contact__Cost__LCY__; "Cost (LCY)") { } column(Contact__Estimated_Value__LCY__; "Estimated Value (LCY)") { } column(Contact__Calcd__Current_Value__LCY__; "Calcd. Current Value (LCY)") { } column(Contact__No__of_Opportunities_; "No. of Opportunities") { } column(Contact__Duration__Min___; "Duration (Min.)") { } column(Contact__Next_Task_Date_; Format("Next Task Date")) { } column(Contact_Type; Type) { } column(GroupNo; GroupNo) { } column(ContAddr_1_; ContAddr[1]) { } column(ContAddr_2_; ContAddr[2]) { } column(ContAddr_3_; ContAddr[3]) { } column(ContAddr_4_; ContAddr[4]) { } column(ContAddr_5_; ContAddr[5]) { } column(ContAddr_6_; ContAddr[6]) { } column(ContAddr_7_; ContAddr[7]) { } column(ContAddr_8_; ContAddr[8]) { } column(Contact___ListCaption; Contact___ListCaptionLbl) { } column(PageCaption; PageCaptionLbl) { } column(Contact__No__Caption; FieldCaption("No.")) { } column(Contact_TypeCaption; FieldCaption(Type)) { } column(Contact__Cost__LCY__Caption; FieldCaption("Cost (LCY)")) { } column(Contact__No__of_Opportunities_Caption; FieldCaption("No. of Opportunities")) { } column(Contact__Estimated_Value__LCY__Caption; FieldCaption("Estimated Value (LCY)")) { } column(Contact__Calcd__Current_Value__LCY__Caption; FieldCaption("Calcd. Current Value (LCY)")) { } column(Contact__Duration__Min___Caption; FieldCaption("Duration (Min.)")) { } column(Contact__Next_Task_Date_Caption; Contact__Next_Task_Date_CaptionLbl) { } trigger OnAfterGetRecord() begin FormatAddr.ContactAddr(ContAddr, Contact); if Counter = RecPerPageNum then begin GroupNo := GroupNo + 1; Counter := 0; end; Counter := Counter + 1; end; } } requestpage { AboutTitle = 'About Contact List'; AboutText = 'Get list of all your contacts, including related opportunities and to-dos.'; layout { } actions { } } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './CRM/Reports/ContactList.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { } trigger OnPreReport() begin ContactFilter := Contact.GetFilters(); GroupNo := 1; RecPerPageNum := 4; end; var FormatAddr: Codeunit "Format Address"; ContAddr: array[8] of Text[100]; ContactFilter: Text; GroupNo: Integer; Counter: Integer; RecPerPageNum: Integer; Contact___ListCaptionLbl: Label 'Contact - List'; PageCaptionLbl: Label 'Page'; Contact__Next_Task_Date_CaptionLbl: Label 'Next Task Date';}