Solved

Duplicate values getting displayed in Report

  • 13 November 2023
  • 5 replies
  • 67 views
H
Rank
Userlevel 6
Badge +3

Hello Community,
I have been trying to create a report where I would like to display the vendor name (of the subcontracts) in the details section on the basis of the project ID selected. I have implemented the following on GI level and it works fine. But not able to replicate the same in report:

GI:
 


Report:
 

Have used the same as that of GI


 

What is it that I am missing here?
Thank you in advance.​​​​​​​

icon

Best answer by Harshita 13 November 2023, 13:07

View original

5 replies

manikantad18
Rank
Userlevel 7
Badge +12

Hi @Harshita 

Please share XML of GI and report ?

Could you please verify the grouping?

Thanks

Acumatica Functional Consultant
H
Rank
Userlevel 6
Badge +3

Hi @Harshita 

Please share XML of GI and report ?

Could you please verify the grouping?

Thanks

Hello @manikantad18 , attaching the pkg for both GI & report.

1 Attachment
H
Rank
Userlevel 6
Badge +3

Hello @manikantad18 ,
I have resolved the issue. I actually had added the data fields under the DetailSection part instead of the group section part.
 

 

 

H
Rank
Userlevel 6
Badge +3

Hello @manikantad18 ,
I have now been trying to add a subreport to this particular report,
but the values of the particular data field isn’t getting displayed in the report:
 

the highlighted text is getting displayed from the sub-report

Attached here are the updated reports:
TEST0001.rpx is the subreport.

1 Attachment
H
Rank
Userlevel 6
Badge +3

FYI,
the subreport displays the correct values when run individually:
 

 

Reply


Terms & ConditionsCookie 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