Report 1014 Jobs per Item
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';}