Report 5058 Salesperson - Opportunities, source in 29
Source29
src/Layers/W1/BaseApp/CRM/Reports/SalespersonOpportunities.Report.al161 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.Opportunity;
report 5058 "Salesperson - Opportunities"
{
ApplicationArea = Basic, Suite;
Caption = 'Salesperson Opportunities';
ToolTip = 'View information about the opportunities handled by one or several salespeople.';
UsageCategory = ReportsAndAnalysis;
DefaultRenderingLayout = RDLCLayout;
dataset
{
dataitem(Opportunity; Opportunity)
{
DataItemTableView = sorting("Salesperson Code", Closed);
RequestFilterFields = "Salesperson Code", "No.", "Campaign No.", "Contact No.", "Creation Date", Closed, "Date Closed";
column(FORMAT_TODAY_0_4_; Format(Today, 0, 4))
{
}
column(COMPANYNAME; COMPANYPROPERTY.DisplayName())
{
}
column(Opportunity_TABLECAPTION__________OpportunityFilter; TableCaption + ': ' + OpportunityFilter)
{
}
column(OpportunityFilter; OpportunityFilter)
{
}
column(Opportunity__Salesperson_Name_; "Salesperson Name")
{
}
column(Opportunity__Salesperson_Code_; "Salesperson Code")
{
}
column(Opportunity__No__; "No.")
{
}
column(Opportunity__Contact_No__; "Contact No.")
{
}
column(Opportunity__Creation_Date_; Format("Creation Date"))
{
}
column(Opportunity_Status; Status)
{
}
column(Opportunity_Priority; Priority)
{
}
column(Opportunity__Probability___; "Probability %")
{
}
column(Opportunity__Chances_of_Success___; "Chances of Success %")
{
}
column(Opportunity__Completed___; "Completed %")
{
}
column(Opportunity__Campaign_No__; "Campaign No.")
{
}
column(Opportunity__Date_Closed_; Format("Date Closed"))
{
}
column(Opportunity_Description; Description)
{
}
column(FooterPrinted; FooterPrinted)
{
}
column(Salesperson___OpportunityCaption; Salesperson___OpportunityCaptionLbl)
{
}
column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)
{
}
column(Opportunity__No__Caption; FieldCaption("No."))
{
}
column(Opportunity__Contact_No__Caption; FieldCaption("Contact No."))
{
}
column(Opportunity__Creation_Date_Caption; Opportunity__Creation_Date_CaptionLbl)
{
}
column(Opportunity_StatusCaption; FieldCaption(Status))
{
}
column(Opportunity_PriorityCaption; FieldCaption(Priority))
{
}
column(Opportunity__Probability___Caption; FieldCaption("Probability %"))
{
}
column(Opportunity__Chances_of_Success___Caption; FieldCaption("Chances of Success %"))
{
}
column(Opportunity__Completed___Caption; FieldCaption("Completed %"))
{
}
column(Opportunity__Campaign_No__Caption; FieldCaption("Campaign No."))
{
}
column(Opportunity__Date_Closed_Caption; Opportunity__Date_Closed_CaptionLbl)
{
}
column(Opportunity_DescriptionCaption; FieldCaption(Description))
{
}
}
}
requestpage
{
AboutTitle = 'About Salesperson Opportunities';
AboutText = 'Review which salespeople handle which opportunities.';
layout
{
}
actions
{
}
}
rendering
{
layout(RDLCLayout)
{
Type = RDLC;
LayoutFile = './CRM/Reports/SalespersonOpportunities.rdlc';
Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';
}
}
labels
{
}
trigger OnPreReport()
begin
OpportunityFilter := Opportunity.GetFilters();
end;
var
FooterPrinted: Boolean;
OpportunityFilter: Text;
Salesperson___OpportunityCaptionLbl: Label 'Salesperson - Opportunity';
CurrReport_PAGENOCaptionLbl: Label 'Page';
Opportunity__Creation_Date_CaptionLbl: Label 'Creation Date';
Opportunity__Date_Closed_CaptionLbl: Label 'Date Closed';
}