Question

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

  • 19 January 2021
  • 2 replies
  • 53 views

Userlevel 4
Badge

Hello,

      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

 


2 replies

Userlevel 1
Badge +1

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 4
Badge

@meganfriesen37 
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?

Reply


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 — 2020  Acumatica, Inc. All rights reserved