Skip to main content

Hi! Is it possible to concatenate these values after group by?

 I want the output to be “Order Fulfillment, Customer Experience” since they just belong to a single activity.

Here’s my GI:


I dont believe you can do ths using the Standard GI functionality as there is not an Aggreate Option for Concat on a string value. Your other option would be to create a SQL view to do this and then use this as a DAC for your Generic Inquiry.

https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/


I dont believe you can do ths using the Standard GI functionality as there is not an Aggreate Option for Concat on a string value. Your other option would be to create a SQL view to do this and then use this as a DAC for your Generic Inquiry.

https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/

Thank you so much!


Reply