Skip to main content
Question

How to display a Text Field only once?

  • October 6, 2023
  • 1 reply
  • 60 views
R
Freshman II
Forum|alt.badge.img

Hi,

 

we have 2 non-stock items in a record in the sales order screen.
 


we need to display these non-stock items in the Proforma Invoice report. 
we have created a sub report and added it to the main report to get non-stock items.
 

 

here is the visible expression for the section.
 


and here is the condition to the text field “Freight & Misc”.
​​​​​​​


there is also a Variable called counter.
​​​​​​​



when we run the report, it displays the text field for every single non-stock item record.
 



Can anyone please let me know is there anyway to avoid this and display “Freight & Misc” field only once.

Thank you.

1 reply

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • October 6, 2023

@RManathungage94 It seems you are setting the visibility condition from within the subreport, but this will not carry into the main report.

You need to specify the visibility condition inside the main report, though it looks like you have specified a visibility expression and marked the whole section as Visible = False, so if you so this in the main report it will never show.

You would need to call in the subreport variable or specify this in the main report instead, basically all the conditions you set in the sub should be moved the main report and check to see if that works better.

Think of the subreport as just an additional page(s) to the main report, it’s meant to follow the formatting of the main report instead of bringing any formatting from the sub.

Chris Hackett
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