Is there a way to extract data from JRS into a Report such that multi-enumerations are on a single row for the same artifact and not on separate lines (with each line for each different enumerated value)?
JRS Report Builder 6.0.5 is putting multiple enumeration valued attributes (that are in a Rational DOORS Next Gen Project) on separate lines for the same artifact ID.
3 answers
Hi Michael,
I don't know how you would do this without dropping into Advanced SQL. It would be tricky even then because you would have to concatenate all of the individual enum literals (which implies to have to know how many you have and how many are possible). Just thinking out loud -- I'm no SQL expert, but I spent about 15 minutes looking at it and nothing popped out at me.
Amy
This blog post on streamlining multi-value enumerations by showing the values in a single line might help:
https://jazz.net/blog/index.php/2017/06/22/jrs-report-builder-streamlining-multi-value-enumerations-in-reports/