String Aggregation Type - Distinc String Concatenate

[brett.macpherson]

Hi,
writing some reports which involves aggregating data sets which have numeric and string values. The requirements are to aggregate the data into groups for the numerics using sum/avg styles however with the string data types the only options are first/last/count/count(distinc). It would be handy to have an aggregation style called "Distinc String Concatenate". This would work similarly to the SQL function STRING_AGG but only return the distinc strings with a seperator as a single string. This would allow you to show all the string values in a single row when aggregating.

https://learn.microsoft.com/en-us/sql/t ... rver-ver16

Regards,
Brett

[Lech Kulikowski]

Hello,

You can add your own function
https://www.stimulsoft.com/en/documenta ... ctions.htm

Thank you.