Report 5051 Contact - Company Summary

Base Application, Microsoft.CRM.Reports

src/Layers/W1/BaseApp/CRM/Reports/ContactCompanySummary.Report.al311 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.Interaction;using Microsoft.CRM.Task;using Microsoft.Foundation.Address;report 5051 "Contact - Company Summary"{    ApplicationArea = Basic, Suite;    Caption = 'Contact - Company Summary';    UsageCategory = ReportsAndAnalysis;    WordMergeDataItem = Contact;    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem(Contact; Contact)        {            DataItemTableView = sorting("Company No.") where(Type = const(Company));            RequestFilterFields = "Company No.", "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(ContactFilter; ContactFilter)            {            }            column(Contact__Company_No__; "Company No.")            {            }            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__Phone_No__; "Phone No.")            {            }            column(Contact__E_Mail_; "E-Mail")            {            }            column(Contact___Company_SummaryCaption; Contact___Company_SummaryCaptionLbl)            {            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {            }            column(Contact__Company_No__Caption; FieldCaption("Company No."))            {            }            column(Contact__Phone_No__Caption; FieldCaption("Phone No."))            {            }            column(Contact__E_Mail_Caption; FieldCaption("E-Mail"))            {            }            dataitem("<ContactPerson>"; Contact)            {                DataItemLink = "Company No." = field("Company No.");                DataItemTableView = sorting("Company No.") where(Type = filter(Person));                column(ContactPerson___No__; "No.")                {                }                column(ContactPerson__Name; Name)                {                }                column(ContactPerson___Job_Title_; "Job Title")                {                }                column(ContactPerson___Phone_No__; "Phone No.")                {                }                column(ContactPerson___E_Mail_; "E-Mail")                {                }                column(ContactPerson__NameCaption; FieldCaption(Name))                {                }                column(ContactPerson___No__Caption; FieldCaption("No."))                {                }                column(PersonsCaption; PersonsCaptionLbl)                {                }                column(ContactPerson___Job_Title_Caption; FieldCaption("Job Title"))                {                }                column(ContactPerson___Phone_No__Caption; FieldCaption("Phone No."))                {                }                column(ContactPerson___E_Mail_Caption; FieldCaption("E-Mail"))                {                }            }            dataitem("To-do"; "To-do")            {                DataItemLink = "Contact Company No." = field("Company No.");                DataItemTableView = sorting("Contact Company No.", "Contact No.", Closed, Date) where("System To-do Type" = const("Contact Attendee"));                RequestFilterFields = Closed, Date, Type;                column(Task_Description; Description)                {                }                column(Task_Date; Format(Date))                {                }                column(Task_Status; Status)                {                }                column(Task_Priority; Priority)                {                }                column(Task_Type; Type)                {                }                column(Task__Team_Code_; "Team Code")                {                }                column(Task__Salesperson_Code_; "Salesperson Code")                {                }                column(Task__Contact_No__; "Contact No.")                {                }                column(Task__No__; "No.")                {                }                column(Format_Closed; Format(Closed))                {                }                column(TasksCaption; TasksCaptionLbl)                {                }                column(DateCaption; DateCaptionLbl)                {                }                column(DescriptionCaption; DescriptionCaptionLbl)                {                }                column(TypeCaption; TypeCaptionLbl)                {                }                column(StatusCaption; StatusCaptionLbl)                {                }                column(PriorityCaption; PriorityCaptionLbl)                {                }                column(Team_CodeCaption; Team_CodeCaptionLbl)                {                }                column(Salesperson_CodeCaption; Salesperson_CodeCaptionLbl)                {                }                column(ClosedCaption; ClosedCaptionLbl)                {                }                column(Task__Contact_No__Caption; FieldCaption("Contact No."))                {                }                column(Task__No__Caption; FieldCaption("No."))                {                }            }            dataitem("<Interaction Log Entry>"; "Interaction Log Entry")            {                DataItemLink = "Contact Company No." = field("Company No.");                DataItemTableView = sorting("Contact Company No.", "Contact No.", Date) where(Postponed = const(false));                RequestFilterFields = Date, "Interaction Group Code", "Interaction Template Code", "Information Flow", "Initiated By";                column(Interaction_Log_Entry__Description; Description)                {                }                column(Interaction_Log_Entry___Information_Flow_; "Information Flow")                {                }                column(Interaction_Log_Entry___Initiated_By_; "Initiated By")                {                }                column(Interaction_Log_Entry__Date; Format(Date))                {                }                column(Interaction_Log_Entry___Contact_No__; "Contact No.")                {                }                column(Interaction_Log_Entry___Task_No__; "To-do No.")                {                }                column(Interaction_Log_Entry___Entry_No__; "Entry No.")                {                }                column(Interaction_Log_Entry___Salesperson_Code_; "Salesperson Code")                {                }                column(InteractionsCaption; InteractionsCaptionLbl)                {                }                column(Interaction_Log_Entry__DescriptionCaption; FieldCaption(Description))                {                }                column(Interaction_Log_Entry___Information_Flow_Caption; FieldCaption("Information Flow"))                {                }                column(Interaction_Log_Entry___Initiated_By_Caption; FieldCaption("Initiated By"))                {                }                column(DateCaption_Control88; DateCaption_Control88Lbl)                {                }                column(Interaction_Log_Entry___Contact_No__Caption; FieldCaption("Contact No."))                {                }                column(Interaction_Log_Entry___Task_No__Caption; FieldCaption("To-do No."))                {                }                column(Interaction_Log_Entry___Entry_No__Caption; FieldCaption("Entry No."))                {                }                column(Interaction_Log_Entry___Salesperson_Code_Caption; FieldCaption("Salesperson Code"))                {                }            }            trigger OnAfterGetRecord()            begin                FormatAddr.ContactAddr(ContAddr, Contact);            end;        }    }    requestpage    {        AboutTitle = 'About Contact - Company Summary';        AboutText = 'Get an overview of your contact companies, including related interactions and to-dos.';        layout        {        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './CRM/Reports/ContactCompanySummary.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();    end;    var        FormatAddr: Codeunit "Format Address";        ContactFilter: Text;        ContAddr: array[8] of Text[100];        Contact___Company_SummaryCaptionLbl: Label 'Contact - Company Summary';        CurrReport_PAGENOCaptionLbl: Label 'Page';        PersonsCaptionLbl: Label 'Persons';        TasksCaptionLbl: Label 'Tasks';        DateCaptionLbl: Label 'Date';        DescriptionCaptionLbl: Label 'Description';        TypeCaptionLbl: Label 'Type';        StatusCaptionLbl: Label 'Status';        PriorityCaptionLbl: Label 'Priority';        Team_CodeCaptionLbl: Label 'Team Code';        Salesperson_CodeCaptionLbl: Label 'Salesperson Code';        ClosedCaptionLbl: Label 'Closed';        InteractionsCaptionLbl: Label 'Interactions';        DateCaption_Control88Lbl: Label 'Date';}