Solved

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

  • 26 April 2023
  • 3 replies
  • 150 views

Userlevel 4
Badge

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.

icon

Best answer by kdavis45 26 April 2023, 17:37

View original

3 replies

Userlevel 4
Badge +1

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.

Userlevel 7
Badge +10

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

Badge +11

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

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