Report 6211 Emission Per Facility

Sustainability, Microsoft.Sustainability.Reports

src/Apps/W1/Sustainability/app/src/Reports/EmissionPerFacility.Report.al160 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.Sustainability.Reports;using Microsoft.Inventory.Location;using Microsoft.Sustainability.Ledger;using Microsoft.Sustainability.Setup;report 6211 "Emission Per Facility"{    DefaultRenderingLayout = EmissionPerFacilityExcel;    ApplicationArea = Basic, Suite;    Caption = 'Emission Per Facility';    UsageCategory = ReportsAndAnalysis;    DataAccessIntent = ReadOnly;    dataset    {        dataitem("Sustainability Ledger Entry"; "Sustainability Ledger Entry")        {            DataItemTableView = sorting("Entry No.");            RequestFilterFields = "Posting Date", "Responsibility Center", "Account No.";            column(PeriodFilter; StrSubstNo(PeriodLbl, SustLedgDateFilter))            {            }            column(SustLedgDateFilter; SustLedgDateFilter)            {            }            column(CompanyName; CompanyProperty.DisplayName())            {            }            column(ShowDetails; ShowDetails)            {            }            column(Responsibility_Center; "Responsibility Center")            {                IncludeCaption = true;            }            column(Responsibility_Center_Name; ResponsibilityCenter.Name)            {                IncludeCaption = true;            }            column(Account_No_; "Account No.")            {                IncludeCaption = true;            }            column(Account_Name; "Account Name")            {                IncludeCaption = true;            }            column(Description; Description)            {                IncludeCaption = true;            }            column(Unit_of_Measure; ReportingUOMCode)            {            }            column(UnitOfMeasureCaption; FieldCaption("Unit of Measure"))            {            }            column(Emission_Scope; "Emission Scope")            {                IncludeCaption = true;            }            column(Country_Region_Code; "Country/Region Code")            {                IncludeCaption = true;            }            column(Emission_CO2; "Emission CO2")            {                IncludeCaption = true;            }            column(Emission_CH4; "Emission CH4")            {                IncludeCaption = true;            }            column(Emission_N2O; "Emission N2O")            {                IncludeCaption = true;            }            trigger OnAfterGetRecord()            begin                if not ResponsibilityCenter.Get("Responsibility Center") then                    Clear(ResponsibilityCenter);                if UseReportingUOMFactor then begin                    "Emission CO2" := Round("Emission CO2" * ReportingUOMFactor, RoundingPrecision, RoundingDirection);                    "Emission CH4" := Round("Emission CH4" * ReportingUOMFactor, RoundingPrecision, RoundingDirection);                    "Emission N2O" := Round("Emission N2O" * ReportingUOMFactor, RoundingPrecision, RoundingDirection);                end;            end;        }    }    requestpage    {        AboutText = 'This report encompasses greenhouse gas (GHG) emission data documented across various facilities - Responsibility Centers.';        AboutTitle = 'About Emission Per Facility';    }    rendering    {        layout(EmissionPerFacilityExcel)        {            Type = Excel;            Caption = 'Emission Per Facility Excel Layout';            LayoutFile = './src/Reports/EmissionPerFacility.xlsx';            Summary = 'Built in layout for the Emission Per Facility excel report. This report encompasses greenhouse gas (GHG) emission data documented across various facilities - Responsibility Centers.';        }        layout(EmissionPerFacilityRDLC)        {            Type = RDLC;            Caption = 'Emission Per Facility RDLC Layout';            LayoutFile = './src/Reports/EmissionPerFacility.rdlc';            Summary = 'Built in layout for the Emission Per Facility RDLC report. This report encompasses greenhouse gas (GHG) emission data documented across various facilities - Responsibility Centers.';        }    }    labels    {        EmissionPerFacility = 'Emission Per Facility';        EmissionPerFacilityPrint = 'Emission Per Facility (Print)', MaxLength = 31, Comment = 'Excel worksheet name.';        PageCaption = 'Page';        EmissionsByRespCenter = 'Emissions by R. C.', MaxLength = 31, Comment = 'Excel worksheet name.';        AverageByScopeAndRC = 'Average by Scope and R. C.', MaxLength = 31, Comment = 'Excel worksheet name.';        AverageByAccountAndRC = 'Average by Account and R. C.', MaxLength = 31, Comment = 'Excel worksheet name.';        CompName = 'Company Name';        CountryRegionCode = 'Country/Region Code';        EmissionByRespCenter = 'Emissions by Responsibility Center';        EmissionScope = 'Emission Scope';        ResponsibilityCenter = 'Responsibility Center';        SumOfEmission_CO2 = 'Sum of Emission CO2';        SumOfEmission_CH4 = 'Sum of Emission CH4';        SumOfEmission_N2O = 'Sum of Emission N2O';        AverageOfEmission_CO2 = 'Average of Emission CO2';        AverageOfEmission_CH4 = 'Average of Emission CH4';        AverageOfEmission_N2O = 'Average of Emission N2O';        AccountName = 'Account Name';        DataRetrieved = 'Data retrieved:';        // About the report labels        AboutTheReportLabel = 'About the report', MaxLength = 31, Comment = 'Excel worksheet name.';        EnvironmentLabel = 'Environment';        CompanyLabel = 'Company';        UserLabel = 'User';        RunOnLabel = 'Run on';        ReportNameLabel = 'Report name';        DocumentationLabel = 'Documentation';    }    trigger OnPreReport()    var        SustainabilitySetup: Record "Sustainability Setup";    begin        SustLedgDateFilter := "Sustainability Ledger Entry".GetFilter("Posting Date");        SustainabilitySetup.GetReportingParameters(ReportingUOMCode, UseReportingUOMFactor, ReportingUOMFactor, RoundingDirection, RoundingPrecision);    end;    var        ResponsibilityCenter: Record "Responsibility Center";        ReportingUOMCode: Code[10];        SustLedgDateFilter, RoundingDirection : Text;        ReportingUOMFactor, RoundingPrecision : Decimal;        ShowDetails, UseReportingUOMFactor : Boolean;        PeriodLbl: Label 'Period: %1', Comment = '%1 - period filter';}