How to avoid a row repeating in report?
I am building a Report in Report Builder (classic). This report must return work item A and its Resolved by work items B. There's a common attribute I need to verify, this attribute is coming from an enumeration. The attribute in work item A is configured as a picker list (multiple selections possible), while in work item B it is configured as a simple enumeration (only one selection possible).
I have managed to get the report to show work item A and its resolved by's, but it duplicates/triplicates them. Ie. If in work item A, the picker list contains options 1 and 2, the report returns next to work item A, 2 work items B in EACH of the options, so a total of 4.
Picture below to better explain.
Thank you in advance.
One answer
For multiselect enumerations, you will need to use a custom attribute and concatenate them into a single value using LISTAGG for a DW/SQL based based datasource or GROUP_CONCAT for an LQE SPARQL based data source.
There are quite a few examples of how to do this in the forums and online, but let me know if you can't find one