Skip to main content
Solved

Suppress Blank Subreport

  • February 18, 2025
  • 3 replies
  • 94 views
frankneo
Freshman II
Forum|alt.badge.img

I have a Production with 2 operations.  One operation does not have any inventory required while the other has inventory. 


I added a barcode for the inventory ID so that a barcode scanner can be used in the Materials Subreport.  However, the Subreport printed the barcode picture even though there is no inventory in the operation. 

I tried using the visible expression to only appear if there is inventory but no matter what I do, the blank subreport will still print the barcode picture.  The Visible Expression “[AMProdMatl.InventoryID]<>null” was entered into every field or sections with no impact.

 

How to suppress the subreport when the subreport does not have any values?

Best answer by frankneo

I found the solution which is to have the visible expression in the main report for the sub report section as

“=[AMProdOper.LineCntrMatl]>0”

3 replies

V
Acumatica Employee
Forum|alt.badge.img+12
  • vkumar
  • Acumatica Support Team
  • February 18, 2025

Hi ​@frankneo 

Please try changing the process order and check the result.  Set it to ‘WhilePrint’

Regards,

VijayKumarU
    frankneo
    Freshman II
    Forum|alt.badge.img
    • frankneo
    • Author
    • Freshman II
    • Answer
    • February 18, 2025

    I found the solution which is to have the visible expression in the main report for the sub report section as

    “=[AMProdOper.LineCntrMatl]>0”

      V
      Acumatica Employee
      Forum|alt.badge.img+12
      • vkumar
      • Acumatica Support Team
      • February 18, 2025

      Hi ​@frankneo 

      Nice! Initially, I assumed that the visibility expression was set on main report. Glad to know the issue is resolved now.

      Regards,

      VijayKumarU
        Terms & ConditionsCookie settingsAccessibility statement
        About Acumatica ERP system
        Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
        © 2008 — 2024  Acumatica, Inc. All rights reserved