Solved

Add Screen Attributes into Report Designer

  • 29 February 2024
  • 1 reply
  • 41 views

Userlevel 2
Badge

Hello Community,

Need your help to show specific fields (green dots) in Employee’s attributes tab on Report Designer as shown in element’ screen below.

Tried to relate EPEmployee and CSAnswer as “EmployeeAttr”

and in Field value, putted

='Binding'+IIf([EmployeeAttr.AttributeID]<>null,[EmployeeAttr.AttributeID]+'{br}','')

the result still empty.

Looking forward further solution for these.

 

Cheers

icon

Best answer by Sagar Greytrix 29 February 2024, 06:09

View original

1 reply

Userlevel 5
Badge +1

Hi @satwikh1 ,

You need to join the CSAnswer table to the CSAttribute table and further join the CSAttribute to CSAttributeDetail by AttributeID to retrieve the attribute values.

This link can be helpful to you.

Regards,

Sagar, Greytrix

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