Report 811 Assembly BOM - Subassemblies
src/Layers/W1/BaseApp/Assembly/Reports/AssemblyBOMSubassemblies.Report.al116 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.Assembly.Reports;using Microsoft.Inventory.BOM;using Microsoft.Inventory.Item;report 811 "Assembly BOM - Subassemblies"{ AdditionalSearchTerms = 'bill of material sub-assemblies'; ApplicationArea = Assembly; Caption = 'BOM - Sub-Assemblies'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem(Item; Item) { DataItemTableView = where("Assembly BOM" = const(true)); RequestFilterFields = "No.", "Base Unit of Measure", "Shelf No."; column(CompanyName; COMPANYPROPERTY.DisplayName()) { } column(temFilter_Item; TableCaption + ': ' + ItemFilter) { } column(ItemFilter; ItemFilter) { } column(No_Item; "No.") { IncludeCaption = true; } column(Description_Item; Description) { IncludeCaption = true; } column(BaseUnitofMeasure_Item; "Base Unit of Measure") { IncludeCaption = true; } column(Inventory_Item; Inventory) { IncludeCaption = true; } column(UnitCost_Item; "Unit Cost") { IncludeCaption = true; } column(AlternativeItemNo_Item; "Alternative Item No.") { IncludeCaption = true; } column(BOMSubAssembliesCaption; BOMSubAssembliesCaptionLbl) { } column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl) { } trigger OnAfterGetRecord() begin BOMComp.Reset(); BOMComp.SetCurrentKey(Type, "No."); BOMComp.SetRange(Type, BOMComp.Type::Item); BOMComp.SetRange("No.", "No."); if not BOMComp.FindFirst() then // Not part of a BOM CurrReport.Skip(); end; } } requestpage { AboutTitle = 'About BOM - Sub-Assemblies'; AboutText = 'Get an overview of the components in a sub-assembly bill of materials, for both assembly and production.'; layout { } actions { } } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './Assembly/Reports/AssemblyBOMSubassemblies.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(); end; var BOMComp: Record "BOM Component"; ItemFilter: Text; BOMSubAssembliesCaptionLbl: Label 'BOM - Sub-Assemblies'; CurrReportPageNoCaptionLbl: Label 'Page';}