Attempting to print multiple attribute values in one row in JRS 6.0.3
Greetings!
I'm attempting to put together a JRS report that lists the (comma separated) multiple attribute values for each record in one row, instead of a row for each value.
Here's what I have...
SELECT DISTINCT T1.REFERENCE_ID,
The attribute called 'Variant' is the source of the multiple values.
I'm trying to find the correct function and syntax to make this happen. Can't seem to get LISTAGG to work, and can't find the right syntax for CONCATENATE to make that work either.
Any clues?
Thanks in advance.
|
One answer
Hi,
IBM has posted a support article here in regards to this question.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.