AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
Nested SubReport Is...
 
Notifications
Clear all

Nested SubReport Issue

 
Acumatica Report Designer
Last Post by cschwark 60 minutes ago
1 Posts
1 Users
0 Reactions
4 Views
RSS
cschwark
Posts: 2
 cschwark
Topic starter
May 5, 2026 7:09 pm
(@cschwark)
New Member
Joined: 5 years ago

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 Required and Visible on WONbr parameter in AM64000A
  • Hidden the nested materials SubReport inside AM64000A (no change)
  • Removed OrderType from 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!

am64000a.rpx
shiftexchangechecklistmaterials.rpx
NW62000b.rpx

Forum Jump:
  Previous Topic

Recently viewed by users: cschwark 19 minutes ago.

Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 17 Online
  • 2,420 Members
Our newest member: Katerina Pawlowski
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×