Report 5908 Service Order - Response Time

Base Application, Microsoft.Service.Reports

src/Layers/W1/BaseApp/Service/Reports/ServiceOrderResponseTime.Report.al176 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.Service.History;report 5908 "Service Order - Response Time"{    DefaultLayout = RDLC;    RDLCLayout = './Service/Reports/ServiceOrderResponseTime.rdlc';    ApplicationArea = Service;    Caption = 'Service Order - Response Time';    UsageCategory = ReportsAndAnalysis;    dataset    {        dataitem("Service Shipment Header"; "Service Shipment Header")        {            DataItemTableView = sorting("Responsibility Center", "Posting Date");            RequestFilterFields = "Responsibility Center", "Posting Date";            column(TodayFormatted; Format(Today, 0, 4))            {            }            column(CompanyName; COMPANYPROPERTY.DisplayName())            {            }            column(ServShipHeadFilter1; TableCaption + ': ' + ServShipmentHeaderFilter)            {            }            column(ServShipHeadFilter2; ServShipmentHeaderFilter)            {            }            column(OrderNo_ServShptHdr; "Order No.")            {                IncludeCaption = true;            }            column(CustNo_ServShptHdr; "Customer No.")            {                IncludeCaption = true;            }            column(OrderDate_ServShptHdr; Format("Order Date"))            {            }            column(OrderTime_ServShptHdr; Format("Order Time"))            {            }            column(Name_ServShptHdr; Name)            {                IncludeCaption = true;            }            column(ActualResTimHrs_ServShptHdr; "Actual Response Time (Hours)")            {                IncludeCaption = true;            }            column(StartingDate_ServShptHdr; Format("Starting Date"))            {            }            column(StartingTime_ServShptHdr; Format("Starting Time"))            {            }            column(TotalTime; TotalTime)            {            }            column(TotalCalls; TotalCalls)            {            }            column(TotalTimeFooter; TotalTimeFooter)            {            }            column(TotalCallsFooter; TotalCallsFooter)            {            }            column(AvgResTimeRespCenter; Text000 + FieldCaption("Responsibility Center") + ' ' + "Responsibility Center")            {            }            column(RoundTotalTimeTotalCalls; ActRespTime)            {                DecimalPlaces = 0 : 5;            }            column(AvgResponseTime; AvgResponseTimeLbl)            {            }            column(RespCenter_ServShptHdr; "Responsibility Center")            {            }            column(ServOrderRespTimeCaption; ServOrderRespTimeCaptionLbl)            {            }            column(CurrReportPageNOCaption; CurrReportPageNOCaptionLbl)            {            }            column(ServShptHdrOrderDtCaption; ServShptHdrOrderDtCaptionLbl)            {            }            column(ServShptHdrOrdTimeCaption; ServShptHdrOrdTimeCaptionLbl)            {            }            column(ServShptHdrStartDtCaption; ServShptHdrStartDtCaptionLbl)            {            }            column(ServShptHdrStrtTimCaption; ServShptHdrStrtTimCaptionLbl)            {            }            trigger OnAfterGetRecord()            begin                if LastRespCenterCode <> "Responsibility Center" then begin                    TotalCalls := 0;                    TotalTime := 0;                end;                if ("Order No." <> '') and (LastOrderNo <> "Order No.") then begin                    TotalCalls := TotalCalls + 1;                    TotalTime := TotalTime + "Actual Response Time (Hours)";                    TotalCallsFooter += 1;                    TotalTimeFooter += "Actual Response Time (Hours)";                    LastOrderNo := "Order No.";                end else                    CurrReport.Skip();                LastRespCenterCode := "Responsibility Center";            end;            trigger OnPreDataItem()            begin                TotalTime := 0;            end;        }    }    requestpage    {        AboutTitle = 'About Service Order - Response Time';        AboutText = 'Analyze response times for service orders that are shipped.';        layout        {        }        actions        {        }    }    labels    {    }    trigger OnPreReport()    begin        ServShipmentHeaderFilter := "Service Shipment Header".GetFilters();    end;    var#pragma warning disable AA0074        Text000: Label 'Average Response Time Per ';#pragma warning restore AA0074        ServShipmentHeaderFilter: Text;        TotalTime: Decimal;        TotalCalls: Integer;        LastOrderNo: Code[20];        ActRespTime: Decimal;        TotalCallsFooter: Integer;        TotalTimeFooter: Decimal;        LastRespCenterCode: Code[10];        AvgResponseTimeLbl: Label 'Average Response Time';        ServOrderRespTimeCaptionLbl: Label 'Service Order - Response Time';        CurrReportPageNOCaptionLbl: Label 'Page';        ServShptHdrOrderDtCaptionLbl: Label 'Order Date';        ServShptHdrOrdTimeCaptionLbl: Label 'Order Time';        ServShptHdrStartDtCaptionLbl: Label 'Starting Date';        ServShptHdrStrtTimCaptionLbl: Label 'Starting Time';}