The sub report parameter works only after the sub report be triggered

  • 19 January 2021
  • 3 replies

Userlevel 6
Badge +5


      I’ve studied the article, but I do meet a issue. 

     I write a sub report, and want the sub report be displayed only when it is having count(lines)>0

        Per my test, only when the subreport be trigger at least once, will the

         subReport1_Count having value.


        Like below


3 replies

Userlevel 7
Badge +10

I usually do this as a variable in my sub report to count the number of records there.  Then in the main report, under the Visible Expression I call my sub report variable 

Userlevel 6
Badge +5

Thank you for helping me with this.
Yes, I also add the variable in my sub report to count the number of records
and also I call sub report in main report


My problem is:

$subReport_count will not have value, if I’d like to use it to determine the visibility  of the first call

I can use it, for the second call


So I make the first section invisible all the time, and using the first time’s result to control the second section.

it is working, but can I do it within 1 call?

Userlevel 6
Badge +5


      Did somebody else meet this same kind of issue?
      It is a little bit frustrated if I have to call sub report twice, 

     The first time to get the varible be set value.
      Then, use the frist time’s result to control the the second time’s visibility.


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