Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Prakash Bhai on 06 Mar 2018 09:54:34 AM

Title: Concatenate coloumn values in to single row
Post by: Prakash Bhai on 06 Mar 2018 09:54:34 AM
Hi All,

I have a list report and all the columns I have grouped. I have attached output screenshot. In that I have Item Hierarchy column where I am getting values  in row wise which I have provided in screenshot. But I want those values to be appeared in single column(334,335.516,620)

Regards,
Abhi
Title: Re: Concatenate coloumn values in to single row
Post by: Lynn on 06 Mar 2018 10:00:11 AM
Quote from: Abhi1 on 06 Mar 2018 09:54:34 AM
Hi All,

I have a list report and all the columns I have grouped. I have attached output screenshot. In that I have Item Hierarchy column where I am getting values  in row wise which I have provided in screenshot. But I want those values to be appeared in single column(334,335.516,620)

Regards,
Abhi

I don't see a screenshot attached. Generally a repeater or a crosstab would be a way to pivot information horizontally.
Title: Re: Concatenate coloumn values in to single row
Post by: Prakash Bhai on 06 Mar 2018 10:04:36 AM
Lynn, I have attached the screenshot in a different post. Can you please have a look
Text only | Text with Images