Skip to main content
Answer

Passing Date as a parameter to a sub report

  • December 9, 2024
  • 5 replies
  • 102 views
P
Semi-Pro I
Forum|alt.badge.img+2

I have Develop two reports as CA650000 (main report) and CA650001 (sub report) Both the reports has Date parameters. CA650001 report is used as a sub report inside the CA650000. This sub report takes two parameters as CashAccount and DueDate.  when I run the sub report individually it works fine. when I add the DueDate Parameter it did not pass the values to the main report. when removes the DueDate Param it works fine. DueDate which is get as a parameter in the main report passed as a parameter of the sub report
This is how I pass the parameter to the sub report. 
Following i have attach the reports also

 

Best answer by arthia

Hi ​@PDharmasena10 , The issue with multiple AccountID, it seems. In subreport, both AccountID has value for the specific date. In main report, one of the records only get displayed.

In your instance, check the data for 60002 in subreport. 

Main Report

Sub Report:

Solution: Remove Subreport from group header and add in details section, it seems to be working fine

 

1 Attachments

5 replies

A
Varsity I
Forum|alt.badge.img+3
  • arthia
  • Varsity I
  • December 9, 2024

Hi ​@PDharmasena10 , Attached the modified report,

Main Report Parameter: Based on date selection, it populates data in both main report and sub report

Sub Report:

Main Report:

 

1 Attachments
P
P
Semi-Pro I
Forum|alt.badge.img+2
  • PDharmasena10
  • Author
  • Semi-Pro I
  • December 9, 2024

Hi ​@arthia98 
I saved your updated reports to my instance. But still the issue is exist in my instance. Do you have any idea about the cause for this issue? 

 

A
Varsity I
Forum|alt.badge.img+3
  • arthia
  • Varsity I
  • December 9, 2024

Did you deployed both modified Main and Sub report in your instance? If Yes, run the subreport, check the data and then execute the main report. If possible share the screenshot of parameter selection in main and subreport and the results

Chris Hackett
P
P
Semi-Pro I
Forum|alt.badge.img+2
  • PDharmasena10
  • Author
  • Semi-Pro I
  • December 9, 2024

​@arthia98 

Yes I do so. following is the sub report params and data related to selected Params

 

A
Varsity I
Forum|alt.badge.img+3
  • arthia
  • Varsity I
  • Answer
  • December 9, 2024

Hi ​@PDharmasena10 , The issue with multiple AccountID, it seems. In subreport, both AccountID has value for the specific date. In main report, one of the records only get displayed.

In your instance, check the data for 60002 in subreport. 

Main Report

Sub Report:

Solution: Remove Subreport from group header and add in details section, it seems to be working fine

 

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