Skip to main content
Solved

how to pass a date from a subreport


wfilipiak67
Captain II
Forum|alt.badge.img+3

Hi, 

A client is using the Production Edition. 
The Sales Order lines can be tied to different production orders. 

We are trying to get the earliest start date of the production tickets and print it in the header of the Sales Order. 
I created a subreport that prints the Min ( AMProdItem.StartDate) correctly. I even have it set as a variable that prints $EDate = Min ( AMProdItem.StartDate). These are both printing correctly in the subreport. 

My question is how do I / or can I get the $EDate to be returned? 
When I set the Value as =$subReport1_EDate, I get a zero that prints. 

Or is there a better way to get the earliest start date from multiple production to print on the Sales Order.

Thank you, 
Bill

Best answer by mcraig95

I have had success with sub reports.  Here is where the information is captured.

The next is displaying it in the calling program

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

4 replies

xkylewrightx
Semi-Pro I
Forum|alt.badge.img

Is it possible that there is an issue passing your parameter from the main report to the sub report?

I.e. when running the sub-report from your main report, the sub is not able to determine which sales order you are pulling production tickets for?

Here is information on how to pass the parameter from the main to the sub:

https://help-2022r1.acumatica.com/Help?ScreenId=ShowWiki&pageid=7bbd5bbb-cd1a-4e10-9472-9497deb48f2f


Forum|alt.badge.img+1
  • Varsity I
  • 55 replies
  • Answer
  • March 17, 2023

I have had success with sub reports.  Here is where the information is captured.

The next is displaying it in the calling program


miguel80
Semi-Pro II
Forum|alt.badge.img+1
  • Semi-Pro II
  • 71 replies
  • March 22, 2023

Hello,

Have you checked the reset conditions on the variable? Could you attach a version of the subReport?


Forum|alt.badge.img+12
  • Acumatica Support Team
  • 866 replies
  • March 22, 2023

Hi @wfilipiak67 

Can you confirm the Subreport name reflected is correct (including case) i.e., ‘subReport1’?

$subReport1_EDate

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