Feature Request (SUMSTR)
Hi,
here is my problem:
i have a table with countries.
but on my report i need these countries in one row.
the result should look like: AT,DE,UK,US
so i thought, that the aggregate-function SUM could solve my problem.
but with the normal SUM, the result looked like this:
ATDEUKUS
or with an expression:
AT,DE,UK,US,
So it would be great, to have an aggregate function called like SUMSTR,
where one could define a separator-string:
so a call of this function would look like:
SUMSTR(<expression>,<separator>)
here is my problem:
i have a table with countries.
but on my report i need these countries in one row.
the result should look like: AT,DE,UK,US
so i thought, that the aggregate-function SUM could solve my problem.
but with the normal SUM, the result looked like this:
ATDEUKUS
or with an expression:
AT,DE,UK,US,
So it would be great, to have an aggregate function called like SUMSTR,
where one could define a separator-string:
so a call of this function would look like:
SUMSTR(<expression>,<separator>)