Skip to main content
Solved

Suppress Blank Subreport

  • February 18, 2025
  • 3 replies
  • 26 views

frankneo
Freshman II

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”

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+12
  • Acumatica Support Team
  • 871 replies
  • February 18, 2025

Hi ​@frankneo 

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

Regards,


frankneo
Freshman II
  • Author
  • Freshman II
  • 9 replies
  • 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”


Forum|alt.badge.img+12
  • Acumatica Support Team
  • 871 replies
  • 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,


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings