Report 1014 Jobs per Item

Base Application, Microsoft.Projects.Project.Reports

src/Layers/W1/BaseApp/Projects/Project/Reports/JobsperItem.Report.al191 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.Project.Reports;using Microsoft.Inventory.Item;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Project.Journal;using System.Utilities;report 1014 "Jobs per Item"{    AdditionalSearchTerms = 'Jobs per Item';    ApplicationArea = Jobs;    Caption = 'Projects per Item';    ToolTip = 'View on which project a specific item is used.';    UsageCategory = ReportsAndAnalysis;    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem(Item; Item)        {            PrintOnlyIfDetail = true;            RequestFilterFields = "No.";            column(TodayFormatted; Format(Today))            {            }            column(CompanyName; COMPANYPROPERTY.DisplayName())            {            }            column(ItemTableCaptiontemFilter; TableCaption + ': ' + ItemFilter)            {            }            column(ItemFilter; ItemFilter)            {            }            column(JobTableCaptionJobFilter; Job.TableCaption + ': ' + JobFilter)            {            }            column(JobFilter; JobFilter)            {            }            column(Description_Item; Description)            {            }            column(No_Item; "No.")            {            }            column(Amount3_JobBuffer; TempJobBuffer."Amount 3")            {            }            column(Amount2_JobBuffer; TempJobBuffer."Amount 2")            {            }            column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl)            {            }            column(JobsperItemCaption; JobsperItemCaptionLbl)            {            }            column(AllamountsareinLCYCaption; AllamountsareinLCYCaptionLbl)            {            }            column(JobNoCaption; JobNoCaptionLbl)            {            }            column(JobBufferDscrptnCaption; JobBufferDscrptnCaptionLbl)            {            }            column(JobBufferQuantityCaption; JobBufferQuantityCaptionLbl)            {            }            column(JobBufferUOMCaption; JobBufferUOMCaptionLbl)            {            }            column(JobBufferTotalCostCaption; JobBufferTotalCostCaptionLbl)            {            }            column(JobBufferLineAmountCaption; JobBufferLineAmountCaptionLbl)            {            }            column(TotalCaption; TotalCaptionLbl)            {            }            dataitem("Integer"; "Integer")            {                DataItemTableView = sorting(Number) where(Number = filter(1 ..));                column(AccountNo1_JobBuffer; TempJobBuffer."Account No. 1")                {                }                column(Description_JobBuffer; TempJobBuffer.Description)                {                }                column(AccountNo2_JobBuffer; TempJobBuffer."Account No. 2")                {                }                column(Amount1_JobBuffer; TempJobBuffer."Amount 1")                {                    DecimalPlaces = 0 : 5;                }                column(TableCapionItemNo; Text000 + ' ' + Item.TableCaption + ' ' + Item."No.")                {                }                trigger OnAfterGetRecord()                begin                    if Number = 1 then begin                        if not TempJobBuffer.Find('-') then                            CurrReport.Break();                    end else                        if TempJobBuffer.Next() = 0 then                            CurrReport.Break();                end;            }            trigger OnAfterGetRecord()            begin                TempJobBuffer2.ReportItemJob(Item, Job, TempJobBuffer);            end;        }        dataitem(Job2; Job)        {            RequestFilterFields = "No.", "Bill-to Customer No.", "Posting Date Filter";            trigger OnPreDataItem()            begin                CurrReport.Break();            end;        }    }    requestpage    {        AboutTitle = 'About Projects per Item';        AboutText = 'Get an overview of how you use items in your projects.';        layout        {        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Projects/Project/Reports/JobsperItem.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        ItemFilter := Item.GetFilters();        Job.CopyFilters(Job2);        JobFilter := Job.GetFilters();    end;    var        Job: Record Job;        TempJobBuffer2: Record "Job Buffer" temporary;        TempJobBuffer: Record "Job Buffer" temporary;        JobFilter: Text;        ItemFilter: Text;#pragma warning disable AA0074        Text000: Label 'Total for';#pragma warning restore AA0074        CurrReportPageNoCaptionLbl: Label 'Page';        JobsperItemCaptionLbl: Label 'Projects per Item';        AllamountsareinLCYCaptionLbl: Label 'All amounts are in LCY';        JobNoCaptionLbl: Label 'Project No.';        JobBufferDscrptnCaptionLbl: Label 'Description';        JobBufferQuantityCaptionLbl: Label 'Quantity';        JobBufferUOMCaptionLbl: Label 'Unit of Measure';        JobBufferTotalCostCaptionLbl: Label 'Total Cost';        JobBufferLineAmountCaptionLbl: Label 'Line Amount';        TotalCaptionLbl: Label 'Total';}