Report 1103 Resource Register

Base Application, Microsoft.Projects.Resources.Ledger

src/Layers/W1/BaseApp/Projects/Resources/Reports/ResourceRegister.Report.al222 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.Projects.Resources.Ledger;report 1103 "Resource Register"{    ApplicationArea = Jobs;    Caption = 'Resource Register';    ToolTip = 'View a list of all the resource registers. Every time a resource entry is posted, a register is created. Every register shows the first and last entry numbers of its entries. You can use the information in a resource register to document when entries were posted.';    UsageCategory = ReportsAndAnalysis;    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("Resource Register"; "Resource Register")        {            DataItemTableView = sorting("No.");            PrintOnlyIfDetail = true;            RequestFilterFields = "No.";            column(FORMAT_TODAY_0_4_; Format(Today, 0, 4))            {            }            column(COMPANYNAME; COMPANYPROPERTY.DisplayName())            {            }            column(Resource_Register__TABLECAPTION__________ResRegFilter; TableCaption + ': ' + ResRegFilter)            {            }            column(ResRegFilter; ResRegFilter)            {            }            column(Resource_Register__No__; "No.")            {            }            column(ChargeableFormat; Format("Res. Ledger Entry".Chargeable))            {            }            column(Res__Ledger_Entry___Total_Price_; "Res. Ledger Entry"."Total Price")            {            }            column(Res__Ledger_Entry___Total_Cost_; "Res. Ledger Entry"."Total Cost")            {            }            column(Resource_RegisterCaption; Resource_RegisterCaptionLbl)            {            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {            }            column(Res__Ledger_Entry_ChargeableCaption; "Res. Ledger Entry".FieldCaption(Chargeable))            {            }            column(Res__Ledger_Entry__Total_Price_Caption; "Res. Ledger Entry".FieldCaption("Total Price"))            {            }            column(Res__Ledger_Entry__Unit_Price_Caption; "Res. Ledger Entry".FieldCaption("Unit Price"))            {            }            column(Res__Ledger_Entry__Unit_of_Measure_Code_Caption; "Res. Ledger Entry".FieldCaption("Unit of Measure Code"))            {            }            column(Res__Ledger_Entry_QuantityCaption; "Res. Ledger Entry".FieldCaption(Quantity))            {            }            column(Res__Ledger_Entry__Unit_Cost_Caption; "Res. Ledger Entry".FieldCaption("Unit Cost"))            {            }            column(Res__Ledger_Entry__Total_Cost_Caption; "Res. Ledger Entry".FieldCaption("Total Cost"))            {            }            column(Res__Ledger_Entry__Entry_Type_Caption; "Res. Ledger Entry".FieldCaption("Entry Type"))            {            }            column(Res__Ledger_Entry__Document_No__Caption; "Res. Ledger Entry".FieldCaption("Document No."))            {            }            column(Res__Ledger_Entry__Posting_Date_Caption; Res__Ledger_Entry__Posting_Date_CaptionLbl)            {            }            column(Res__Ledger_Entry__Resource_No__Caption; "Res. Ledger Entry".FieldCaption("Resource No."))            {            }            column(Res__Ledger_Entry__Work_Type_Code_Caption; "Res. Ledger Entry".FieldCaption("Work Type Code"))            {            }            column(Res__Ledger_Entry__Entry_No__Caption; "Res. Ledger Entry".FieldCaption("Entry No."))            {            }            column(Resource_Register__No__Caption; Resource_Register__No__CaptionLbl)            {            }            column(TotalCaption; TotalCaptionLbl)            {            }            column(Res__Ledger_Entry___Total_Cost_Caption; Res__Ledger_Entry___Total_Cost_CaptionLbl)            {            }            dataitem("Res. Ledger Entry"; "Res. Ledger Entry")            {                DataItemTableView = sorting("Entry No.");                column(Res__Ledger_Entry__Entry_No__; "Entry No.")                {                }                column(Res__Ledger_Entry__Entry_Type_; "Entry Type")                {                }                column(Res__Ledger_Entry__Document_No__; "Document No.")                {                }                column(Res__Ledger_Entry__Posting_Date_; Format("Posting Date"))                {                }                column(Res__Ledger_Entry__Resource_No__; "Resource No.")                {                }                column(Res__Ledger_Entry__Work_Type_Code_; "Work Type Code")                {                }                column(Res__Ledger_Entry__Unit_of_Measure_Code_; "Unit of Measure Code")                {                }                column(Res__Ledger_Entry_Quantity; Quantity)                {                }                column(Res__Ledger_Entry__Unit_Cost_; "Unit Cost")                {                }                column(Res__Ledger_Entry__Total_Cost_; "Total Cost")                {                }                column(Res__Ledger_Entry__Unit_Price_; "Unit Price")                {                }                column(Res__Ledger_Entry__Total_Price_; "Total Price")                {                }                column(Res__Ledger_Entry_Chargeable; Chargeable)                {                }                column(Total_Amount; TotalAmount)                {                }                column(Total_Cost; TotalCost)                {                }                column(TotalSubCost; TotalSubCost)                {                }                column(TotalSubAmount; TotalSubAmount)                {                }                trigger OnAfterGetRecord()                begin                    TotalSubCost += "Total Cost";                    TotalCost += "Total Cost";                    TotalSubAmount += "Total Price";                    TotalAmount += "Total Price";                end;                trigger OnPreDataItem()                begin                    SetRange("Entry No.", "Resource Register"."From Entry No.", "Resource Register"."To Entry No.");                    TotalSubAmount := 0;                    TotalSubCost := 0;                end;            }            trigger OnPreDataItem()            begin                ResRegFilter := GetFilters();                TotalAmount := 0;                TotalCost := 0;            end;        }    }    requestpage    {        AboutTitle = 'About Resource Register';        AboutText = 'Document a resource register''s contents for internal or external audits.';        layout        {        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Projects/Resources/Reports/ResourceRegister.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    var        ResRegFilter: Text;        TotalSubAmount: Decimal;        TotalAmount: Decimal;        TotalSubCost: Decimal;        TotalCost: Decimal;        Resource_RegisterCaptionLbl: Label 'Resource Register';        CurrReport_PAGENOCaptionLbl: Label 'Page';        Res__Ledger_Entry__Posting_Date_CaptionLbl: Label 'Posting Date';        Resource_Register__No__CaptionLbl: Label 'Register No.';        TotalCaptionLbl: Label 'Total';        Res__Ledger_Entry___Total_Cost_CaptionLbl: Label 'Total';}