By using this website, you agree to our Terms of Use (click here)
I have a custom Shift Changeover Checklist report (AM64000A.rpx) that runs perfectly when launched standalone, all fields populate, including a nested SubReport that lists materials. It uses parameters WONbr and OrderType, with filters on AMProdItem.ProdOrdID = @WONbr and AMProdItem.OrderType = @OrderType.
I'm trying to embed this report as a SubReport inside our Production Packet by Date (NW62000B.rpx), which already includes several other subreports (Production Ticket, Pre-Op Checklist, etc.) that work fine. I added a new Detail section in NW62000B with a SubReport control pointing at AM64000A.rpx, passing WONbr = =[AMProdItem.ProdOrdID] and OrderType = =[AMProdItem.OrderType].
When the packet runs, AM64000A's static layout prints (title, labels, panels), but every dynamic field is blank — Work Order number, Date (Today()), Location, Inventory Description, materials list, all empty. The same Detail section works correctly when I temporarily swap ReportName to IN619209.rpx (one of the existing working subreports), so the section wiring is fine. The issue is specific to AM64000A.rpx.
I have tried
- Verified the SubReport Parameters collection (
WONbr,OrderType) — values look correct - Unchecked
RequiredandVisibleonWONbrparameter in AM64000A - Hidden the nested materials SubReport inside AM64000A (no change)
- Removed
OrderTypefrom the parent's parameter pass, falling back to AM64000A's default of "WO" (no change) - Deleted and re-added the SubReport control in the parent
- Duplicated an existing working Detail section instead of creating a new one
- Compared NW62000B's XML — detailSection8 is structurally identical to the working sections
I will attach the Large Packet (Production Packet By Date 62000B), Small Report (Shift Changeover Checklist 64000A) and the subreport if the Shift Changeover (shiftexchangechecklistmaterials)
Hoping to find some help
thank you!
