If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Concatenate rows in to single coloumn

Started by Prakash Bhai, 06 Mar 2018 09:58:21 AM

Previous topic - Next topic

Prakash Bhai

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

Lynn

Quote from: Abhi1 on 06 Mar 2018 09:58:21 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

These look like real companies in your screenshot. Suggest you remove it if so.

I suggested a repeater or a crosstab in the other post you started for this same topic. I think a repeater is worth considering. You'll need to drag one into your list associated with the same query and then do a master detail link between the repeater and the list.