Need to group similar items in a column of a second column in a single line  in a report.

As follows:

Input

Field A   Field B
-----------   -----------
A1             B1
A1            B2
A2            B3
A3            B4
A3      B5

It would become:

Output   
Field A      Field B
------------      -----------
A1         B1, B2
A2         B3
A3         B4, B5

Cognos Version 12.0.4

Quote from: carioca10 on 03 Jun 2025 05:32:50 PMNeed to group similar items in a column of a second column in a single line  in a report.

As follows:

Input

Field A   Field B
-----------   -----------
A1             B1
A1            B2
A2            B3
A3            B4
A3      B5

It would become:

Output   
Field A      Field B
------------      -----------
A1         B1, B2
A2         B3
A3         B4, B5

Cognos Version 12.0.4

Hi,

I'm assuming this is a list report? You could drop a repeater into the second column of the list, and set up a master/detail link between the query of the list and the query of the repeater (based on Column A). Add Column B into the repeater (plus comma/space etc as needed).

Cheers!

MF.