Skip to main content
Solved

Passing Date as a parameter to a sub report

  • December 9, 2024
  • 5 replies
  • 58 views
P
Varsity II
Forum|alt.badge.img+1

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 arthia98

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

 

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

5 replies

A
Jr Varsity III
Forum|alt.badge.img+1
  • arthia98
  • Jr Varsity III
  • 81 replies
  • 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
1 person likes this
  • P
    PDharmasena10
P
Varsity II
Forum|alt.badge.img+1
  • PDharmasena10
  • Author
  • Varsity II
  • 57 replies
  • 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
Jr Varsity III
Forum|alt.badge.img+1
  • arthia98
  • Jr Varsity III
  • 81 replies
  • 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
2 people like this
  • Chris Hackett
    Chris Hackett
  • P
    PDharmasena10
P
Varsity II
Forum|alt.badge.img+1
  • PDharmasena10
  • Author
  • Varsity II
  • 57 replies
  • December 9, 2024

​@arthia98 

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

 

A
Jr Varsity III
Forum|alt.badge.img+1
  • arthia98
  • Jr Varsity III
  • 81 replies
  • 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
2 people like this
  • Chris Hackett
    Chris Hackett
  • P
    PDharmasena10

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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