Report 5981 Contr. Gain/Loss - Resp. Ctr., source in 29
Source29
src/Layers/W1/BaseApp/Service/Reports/ContrGainLossRespCtr.Report.al173 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.Service.Reports;
using Microsoft.Sales.Customer;
using Microsoft.Service.Contract;
report 5981 "Contr. Gain/Loss - Resp. Ctr."
{
DefaultLayout = RDLC;
RDLCLayout = './Service/Reports/ContrGainLossRespCtr.rdlc';
ApplicationArea = Service;
Caption = 'Contr. Gain/Loss - Resp. Ctr.';
UsageCategory = ReportsAndAnalysis;
dataset
{
dataitem("Contract Gain/Loss Entry"; "Contract Gain/Loss Entry")
{
DataItemTableView = sorting("Responsibility Center", "Type of Change", "Reason Code");
RequestFilterFields = "Responsibility Center", "Change Date";
column(TodayFormatted; Format(Today, 0, 4))
{
}
column(CompanyName; COMPANYPROPERTY.DisplayName())
{
}
column(TblCaptContGnLossFilter; TableCaption + ': ' + ContractGainLossFilter)
{
}
column(ContractGainLossFilter; ContractGainLossFilter)
{
}
column(ShowContGainLossDetails; ShowContractGainLossDetails)
{
}
column(RespCenter_ContGnLossEty; "Responsibility Center")
{
IncludeCaption = true;
}
column(TypeofCng_ContGnLossEty; "Type of Change")
{
IncludeCaption = true;
}
column(ReasonCode_ContGnLossEty; "Reason Code")
{
IncludeCaption = true;
}
column(ContNo_ContGnLossEty; "Contract No.")
{
IncludeCaption = true;
}
column(ContGrpCode_ContGnLossEty; "Contract Group Code")
{
IncludeCaption = true;
}
column(CustNo_ContGnLossEty; "Customer No.")
{
IncludeCaption = true;
}
column(Amt_ContGnLossEty; Amount)
{
IncludeCaption = true;
}
column(ChangeDt_ContGnLossEty; Format("Change Date"))
{
}
column(CustName_ContGnLossEty; CustName)
{
}
column(ShiptoCode_ContGnLossEty; "Ship-to Code")
{
IncludeCaption = true;
}
column(TotalFieldCaptReasonCode; StrSubstNo(Text001, "Reason Code", FieldCaption("Reason Code")))
{
}
column(GrandTotFildCaptTypeofCng; StrSubstNo(Text001, "Type of Change", FieldCaption("Type of Change")))
{
}
column(GrandTotFieldCaptRespCent; StrSubstNo(Text001, "Responsibility Center", FieldCaption("Responsibility Center")))
{
}
column(GrandTotal; GrandTotalLbl)
{
}
column(CntrctGainLossRespCenterCaption; CntrctGainLossRespCenterCaptionLbl)
{
}
column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl)
{
}
column(CustomerNameCaption; CustomerNameCaptionLbl)
{
}
column(CntrctGainLossEntryChangeDtCaption; CntrctGainLossEntryChangeDtCaptionLbl)
{
}
trigger OnAfterGetRecord()
begin
CustName := '';
if "Ship-to Code" <> '' then
if ShiptoAddr.Get("Customer No.", "Ship-to Code") then
CustName := ShiptoAddr.Name;
if CustName = '' then
if Cust.Get("Customer No.") then
CustName := Cust.Name;
end;
}
}
requestpage
{
AboutTitle = 'About Contr. Gain/Loss - Resp. Ctr.';
AboutText = 'Analyze gains and losses made on contracts attached to responsibility centers.';
layout
{
area(content)
{
group(Options)
{
Caption = 'Options';
field(ShowContractGainLossDetails; ShowContractGainLossDetails)
{
ApplicationArea = Service;
Caption = 'Show Details';
ToolTip = 'Specifies if you want the report to show details of the contract gain/loss entry.';
}
}
}
}
actions
{
}
}
labels
{
}
trigger OnPreReport()
begin
ContractGainLossFilter := "Contract Gain/Loss Entry".GetFilters();
end;
var
Cust: Record Customer;
ShiptoAddr: Record "Ship-to Address";
ContractGainLossFilter: Text;
CustName: Text[100];
ShowContractGainLossDetails: Boolean;
#pragma warning disable AA0074
#pragma warning disable AA0470
Text001: Label 'The total of entries grouped by the %1 %2';
#pragma warning restore AA0470
#pragma warning restore AA0074
GrandTotalLbl: Label 'Grand Total:';
CntrctGainLossRespCenterCaptionLbl: Label 'Contract Gain/Loss - Responsibility Center';
CurrReportPageNoCaptionLbl: Label 'Page';
CustomerNameCaptionLbl: Label 'Customer Name';
CntrctGainLossEntryChangeDtCaptionLbl: Label 'Change Date';
procedure InitializeRequest(ShowContractGainLossDetailFrom: Boolean)
begin
ShowContractGainLossDetails := ShowContractGainLossDetailFrom;
end;
}