Report 1013 Items per Job
src/Layers/W1/BaseApp/Projects/Project/Reports/ItemsperJob.Report.al192 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 1013 "Items per Job"{ AdditionalSearchTerms = 'Items per Job'; ApplicationArea = Jobs; Caption = 'Items per Project'; ToolTip = 'View which items are used for a specific project.'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem(Job; Job) { DataItemTableView = sorting("No."); PrintOnlyIfDetail = true; RequestFilterFields = "No.", "Posting Date Filter"; column(TodayFormatted; Format(Today)) { } column(CompanyName; COMPANYPROPERTY.DisplayName()) { } column(JobTableCaptionJobFilter; TableCaption + ': ' + JobFilter) { } column(JobFilter; JobFilter) { } column(ItemTableCaptItemFilter; Item.TableCaption + ': ' + ItemFilter) { } column(ItemFilter; ItemFilter) { } column(No_Job; "No.") { } column(Description_Job; Description) { } column(Amount3_JobBuffer; TempJobBuffer."Amount 3") { } column(Amount1_JobBuffer; TempJobBuffer."Amount 2") { } column(ItemsperJobCaption; ItemsperJobCaptionLbl) { } column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl) { } column(AllamountsareinLCYCaption; AllamountsareinLCYCaptionLbl) { } column(JobBufferLineAmountCaption; JobBufferLineAmountCaptionLbl) { } column(JobBufferTotalCostCaption; JobBufferTotalCostCaptionLbl) { } column(JobBuffeUOMCaption; JobBuffeUOMCaptionLbl) { } column(JobBufferQuantityCaption; JobBufferQuantityCaptionLbl) { } column(JobBufferDescriptionCaption; JobBufferDescriptionCaptionLbl) { } column(ItemNoCaption; ItemNoCaptionLbl) { } column(TotalCaption; TotalCaptionLbl) { } dataitem("Integer"; "Integer") { DataItemTableView = sorting(Number) where(Number = filter(1 ..)); column(ActNo1_JobBuffer; TempJobBuffer."Account No. 1") { } column(Description_JobBuffer; TempJobBuffer.Description) { } column(ActNo2_JobBuffer; TempJobBuffer."Account No. 2") { } column(Amount2_JobBuffer; TempJobBuffer."Amount 1") { DecimalPlaces = 0 : 5; } column(TableCaptionJobNo; TotalForTxt + ' ' + Job.TableCaption + ' ' + Job."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.ReportJobItem(Job, Item, TempJobBuffer); end; } dataitem(Item2; Item) { RequestFilterFields = "No."; trigger OnPreDataItem() begin CurrReport.Break(); end; } } requestpage { AboutTitle = 'About Items per Project'; AboutText = 'Get an overview of the items you use in your project.'; layout { } actions { } } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './Projects/Project/Reports/ItemsperJob.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { } trigger OnPreReport() begin Item.CopyFilters(Item2); JobFilter := Job.GetFilters(); ItemFilter := Item.GetFilters(); end; var Item: Record Item; JobFilter: Text; ItemFilter: Text; ItemsperJobCaptionLbl: Label 'Items per Project'; CurrReportPageNoCaptionLbl: Label 'Page'; AllamountsareinLCYCaptionLbl: Label 'All amounts are in LCY'; JobBufferLineAmountCaptionLbl: Label 'Line Amount'; JobBufferTotalCostCaptionLbl: Label 'Total Cost'; JobBuffeUOMCaptionLbl: Label 'Unit of Measure'; JobBufferQuantityCaptionLbl: Label 'Quantity'; JobBufferDescriptionCaptionLbl: Label 'Description'; ItemNoCaptionLbl: Label 'Item No.'; TotalCaptionLbl: Label 'Total'; TotalForTxt: Label 'Total for'; protected var TempJobBuffer2: Record "Job Buffer" temporary; TempJobBuffer: Record "Job Buffer" temporary;}