Greetings,
I am currently attempting to develop a report in IBM Jazz Reporting Service
(6.0.4) and am incurring errors when I attempt to insert SOL code into the
report. Specifically, I have an attribute, called Variant, that contains
multiple values. I am using the LISTAGG function to have those comma-delimited
values appear in one row for for each requirement number (CSSS Tag) in the
report.
I've
researched the syntax for this PL SQL function, and despite numerous attempts,
the report keeps generating errors. I've tried it in DOORS Next Generation,
utilizing both the Custom Expression Builder function, as well as inserting it
directly into the SQL code.
We
are using an ORACLE 12c database for our Jazz data warehouse. Although we
contacted IBM for assistance, they linked us to an article on jazz.net, but it
explicitly states in the post that the example assumes an IBM DB2 warehouse,
which is not our case.
Attached
is a screen grab of the code for a simple report that calls the CCCC Tag (which
is what we call the individual requirement numbers), as well as the Variant
attribute, which is a version of a tent utilized on the project that we
support. Although this is the attribute we're using in this report, we have
several attributes that potentially contain multiple values, so this function
would be used extensively in future reports. Currently, we get a separate row
for each Variant type for each CSSS Tag, which is not acceptable to the
project stakeholders.
I
have also attached a screen grab of a portion of the report results.
If
you could make any suggestions on how/where to insert the LISTAGG syntax into
the report as it appears, it would be greatly appreciated.
Many
thanks!
Carey
Mickelson