COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: suhas_bhat on 02 May 2011 06:39:04 AM

Title: Concatenating dataitem from multiple rows into a single column
Post by: suhas_bhat on 02 May 2011 06:39:04 AM
Hi all,
   I am using a relational package and a list report.
Currently my report looks like this
Col 1 | Col2
A       | abc
A       | xyz
B       | def
C       | pqrs
C       | tuv
I want to display it like this
Col 1 | Col2
A       | abc;xyz
B       | def
C       | pqrs;tuv
Is there any technique to achieve this??
I have tried group by, running count along with conditional styles but data still appears on different rows. I need to concatenate the data into a single row.
Please help.
Title: Re: Concatenating dataitem from multiple rows into a single column
Post by: kattaviz on 02 May 2011 09:59:21 AM
Hi,

Have u tried repeater table option. I think this can be acheived by using Repeater.

HTH
Title: Re: Concatenating dataitem from multiple rows into a single column
Post by: suhas_bhat on 09 May 2011 04:21:01 AM
Hi Kattaviz,
   your soln. of using a repeater works perfectly.
I had fact1 being joined with fact2 to make final_qry.
I have made a copy of final_qry and used the copy for Col2 (which is in a repeater) while the original final_qry is used for the entire list.
Thanks.