Report 5060 Campaign - Details
src/Layers/W1/BaseApp/CRM/Reports/CampaignDetails.Report.al238 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.Campaign;using Microsoft.CRM.Segment;report 5060 "Campaign - Details"{ ApplicationArea = RelationshipMgmt; Caption = 'Campaign - Details'; ToolTip = 'Show detailed information about the campaign.'; UsageCategory = ReportsAndAnalysis; WordMergeDataItem = Campaign; DefaultRenderingLayout = RDLCLayout; dataset { dataitem(Campaign; Campaign) { DataItemTableView = sorting("No."); RequestFilterFields = "No.", "Salesperson Code", "Starting Date", "Ending Date"; column(TodayFormatted; Format(Today, 0, 4)) { } column(CompanyName; COMPANYPROPERTY.DisplayName()) { } column(CampaignFilterCaption; TableCaption + ': ' + CampaignFilter) { } column(CampaignFilter; CampaignFilter) { } column(SegmentHeaderFilterCaption; "Segment Header".TableCaption + ': ' + SegmentHeaderFilter) { } column(SegmentHeaderFilter; SegmentHeaderFilter) { } column(CampaignEntryFilterCaption; "Campaign Entry".TableCaption + ': ' + CampaignEntryFilter) { } column(CampaignEntryFilter; CampaignEntryFilter) { } column(NoofOpportunities_Campaign; "No. of Opportunities") { IncludeCaption = true; } column(DurationMin_Campaign; "Duration (Min.)") { IncludeCaption = true; } column(CostLCY_Campaign; "Cost (LCY)") { IncludeCaption = true; } column(StatusCode_Campaign; "Status Code") { IncludeCaption = true; } column(SalespersonCode_Campaign; "Salesperson Code") { IncludeCaption = true; } column(EndingDate_Campaign; Format("Ending Date")) { } column(StartDate_Campaign; Format("Starting Date")) { } column(Description_Campaign; Description) { } column(No_Campaign; "No.") { } column(CalcCurrValueLCY_Campaign; "Calcd. Current Value (LCY)") { IncludeCaption = true; } column(EstimatedValue_Campaign; "Estimated Value (LCY)") { IncludeCaption = true; } column(CampaignDetailsCaption; CampaignDetailsCaptionLbl) { } column(PageCaption; PageCaptionLbl) { } column(SegmentHdrDateCaption; SegmentHdrDateCaptionLbl) { } column(TypeCaption; TypeCaptionLbl) { } column(CampaignEndingDateCaption; CampaignEndingDateCaptionLbl) { } column(CampaignStartDateCaption; CampaignStartDateCaptionLbl) { } dataitem("Segment Header"; "Segment Header") { DataItemLink = "Campaign No." = field("No."); DataItemTableView = sorting("Campaign No."); column(Date_SegmentHdr; Format(Date)) { } column(Desc_SegmentHdr; Description) { IncludeCaption = true; } column(NoofLines_SegmentHdr; "No. of Lines") { IncludeCaption = true; } column(CostLCY_SegmentHdr; "Cost (LCY)") { IncludeCaption = true; } column(DurInMin_SegmentHdr; "Duration (Min.)") { IncludeCaption = true; } column(SalespersonCode_SegmentHdr; "Salesperson Code") { IncludeCaption = true; } column(No_SegmentHdr; "No.") { IncludeCaption = true; } column(CampaignNo_SegmentHdr; "Campaign No.") { } column(SegCaption; SegCaptionLbl) { } } dataitem("Campaign Entry"; "Campaign Entry") { DataItemLink = "Campaign No." = field("No."); DataItemTableView = sorting("Campaign No.", Date); column(EntryNo_CampaignEntry; "Entry No.") { } column(Canceled_CampaignEntry; Canceled) { IncludeCaption = false; } column(Date_Campaign; Format(Date)) { } column(Desc_Campaign; Description) { } column(SalespersonCode_CampaignEntry; "Salesperson Code") { IncludeCaption = false; } column(NoofInteractions_CampaignEntry; "No. of Interactions") { } column(CostLCY_CampaignEntry; "Cost (LCY)") { } column(DurationMin_CampaignEntry; "Duration (Min.)") { } column(FormatCanceled; Format(Canceled)) { } column(CampaignNo_CampaignEntry; "Campaign No.") { } column(EntryCaption; EntryCaptionLbl) { } } } } requestpage { AboutTitle = 'About Campaign - Details'; AboutText = 'Get an overview of the information related to a campaign.'; layout { } actions { } } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './CRM/Reports/CampaignDetails.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { CanceledCaption = 'Canceled'; } trigger OnPreReport() begin CampaignFilter := Campaign.GetFilters(); SegmentHeaderFilter := "Segment Header".GetFilters(); CampaignEntryFilter := "Campaign Entry".GetFilters(); end; var CampaignFilter: Text; SegmentHeaderFilter: Text; CampaignEntryFilter: Text; CampaignDetailsCaptionLbl: Label 'Campaign - Details'; PageCaptionLbl: Label 'Page'; SegmentHdrDateCaptionLbl: Label 'Date'; TypeCaptionLbl: Label 'Type'; CampaignEndingDateCaptionLbl: Label 'Ending Date'; CampaignStartDateCaptionLbl: Label 'Starting Date'; SegCaptionLbl: Label 'Seg.'; EntryCaptionLbl: Label 'Entry';}