Report 6210 Emission By Category

Sustainability, Microsoft.Sustainability.Reports

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

namespace Microsoft.Sustainability.Reports;using Microsoft.Sustainability.Account;using Microsoft.Sustainability.Ledger;using Microsoft.Sustainability.Setup;report 6210 "Emission By Category"{    DefaultRenderingLayout = EmissionByCategoryExcel;    ApplicationArea = Basic, Suite;    Caption = 'Emission By Category';    UsageCategory = ReportsAndAnalysis;    DataAccessIntent = ReadOnly;    dataset    {        dataitem("Sustainability Ledger Entry"; "Sustainability Ledger Entry")        {            DataItemTableView = sorting("Entry No.");            RequestFilterFields = "Posting Date", "Account Category", "Account No.";            column(PeriodFilter; StrSubstNo(PeriodLbl, SustLedgDateFilter))            {            }            column(SustLedgDateFilter; SustLedgDateFilter)            {            }            column(CompanyName; CompanyProperty.DisplayName())            {            }            column(ShowDetails; ShowDetails)            {            }            column(Account_Category; "Account Category")            {                IncludeCaption = true;            }            column(Account_Category_Description; SustainAccountCategory.Description)            {                IncludeCaption = true;            }            column(Posting_Date; "Posting Date")            {                IncludeCaption = true;            }            column(Document_Type; "Document Type")            {                IncludeCaption = true;            }            column(Document_No_; "Document No.")            {                IncludeCaption = true;            }            column(Account_No_; "Account No.")            {                IncludeCaption = true;            }            column(Account_Name; "Account Name")            {                IncludeCaption = true;            }            column(Description; Description)            {                IncludeCaption = true;            }            column(Emission_Scope; "Emission Scope")            {                IncludeCaption = true;            }            column(Country_Region_Code; "Country/Region Code")            {                IncludeCaption = true;            }            column(Unit_of_Measure; ReportingUOMCode)            {            }            column(UnitOfMeasureCaption; FieldCaption("Unit of Measure"))            {            }            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 SustainAccountCategory.Get("Account Category") then                    Clear(SustainAccountCategory);                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 presents information on greenhouse gas (GHG) emissions categorized by Sustainability Categories.';        AboutTitle = 'About Emission By Category';    }    rendering    {        layout(EmissionByCategoryExcel)        {            Type = Excel;            Caption = 'Emission By Category Excel Layout';            LayoutFile = './src/Reports/EmissionByCategory.xlsx';            Summary = 'Built in layout for the Emission By Category excel report. This report presents information on greenhouse gas (GHG) emissions categorized by Sustainability Categories.';        }        layout(EmissionByCategoryRDLC)        {            Type = RDLC;            Caption = 'Emission By Category RDLC Layout';            LayoutFile = './src/Reports/EmissionByCategory.rdlc';            Summary = 'Built in layout for the Emission By Category RDLC report. This report presents information on greenhouse gas (GHG) emissions categorized by Sustainability Categories.';        }    }    labels    {        EmissionByCategory = 'Emission By Category';        EmissionByCategoryPrint = 'Emission By Category (Print)', MaxLength = 31, Comment = 'Excel worksheet name.';        EmissionByCategoryAnalysis = 'Emission By Category (Analysis)', MaxLength = 31, Comment = 'Excel worksheet name.';        PageCaption = 'Page';        CompName = 'Company Name';        PostingDate = 'Posting Date';        TotalEmissionsperCategory = 'Total Emissions per Category';        SumOfEmission_CO2 = 'Sum of Emission CO2';        SumOfEmission_CH4 = 'Sum of Emission CH4';        SumOfEmission_N2O = 'Sum of Emission N2O';        AccountCategoryDescription = 'Account Category Description';        CategoryDetails = 'Category Details', MaxLength = 31, Comment = 'Excel worksheet name.';        AccountName = 'Account Name';        DocumentType = 'Document Type';        CountryRegionCode = 'Country/Region Code';        EmissionScope = 'Emission Scope';        AccountCategory = 'Account Category';        AccountNo = 'Account No.';        AverageEmissions = 'Average Emissions', MaxLength = 31, Comment = 'Excel worksheet name.';        AverageEmissionsperCategory = 'Average Emissions per Category';        AverageOfEmission_CO2 = 'Average of Emission CO2';        AverageOfEmission_CH4 = 'Average of Emission CH4';        AverageOfEmission_N2O = 'Average of Emission N2O';        EmissionsPerDocument = 'Emissions Per Document', MaxLength = 31, Comment = 'Excel worksheet 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        SustainAccountCategory: Record "Sustain. Account Category";        ReportingUOMCode: Code[10];        SustLedgDateFilter, RoundingDirection : Text;        ShowDetails, UseReportingUOMFactor : Boolean;        ReportingUOMFactor, RoundingPrecision : Decimal;        PeriodLbl: Label 'Period: %1', Comment = '%1 - period filter';}