Skip to main content
Answer

Why is data not passing from the Sub Report to the Main Report?

  • April 26, 2023
  • 3 replies
  • 350 views

Forum|alt.badge.img+1

I created a very simple sub-report with the below specifications. Please see the below screenshots.

Parameter of the sub report
Filter in sub report

This sub-report worked well after being published in the instance. But when I connect this sub-report with my main report, data from the sub-report is not coming. Please see the below screenshot.

 

Main report with sub report

Please give me a support to overcome this issue. Thank you.

Best answer by kdavis45

In the main report, try changing the parameter type from Integer to String. I’ve had success with this, regardless of the parameter type in the subreport.

3 replies

kdavis45
Semi-Pro I
Forum|alt.badge.img+1
  • Semi-Pro I
  • Answer
  • April 26, 2023

In the main report, try changing the parameter type from Integer to String. I’ve had success with this, regardless of the parameter type in the subreport.


Forum|alt.badge.img+9
  • Semi-Pro III
  • April 27, 2023

Hi @malinthawarnakulasooriya08 

 

Here's the link for reference purposes to bring data into the sub-report.

https://www.augforums.com/forums/acumatica-report-designer/sub-report-not-displaying/

 

Hope it helps!

 

Regards,

Sweta


darylbowman
Captain II
Forum|alt.badge.img+15

I can confirm SOOrderNbr is not an integer. It’s a string.