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.