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

Comma separated data from a column

Started by bloggerman, 27 Aug 2008 09:20:19 PM

Previous topic - Next topic

bloggerman

Hi,

I need to retrieve data from a column and display it separated by commas. Table 1 has names of customers and table 2 has claims filed by the customer. I need to join them and display the claim nos comma separated.  E.g. Joe hodden : CLM123,CLM1234,CLM456. Is that possible?

Gopinath

Place a List in your report page. Drag Customer field from Table1 into the list.
Place a Repeater Table inside the list as the second column.
Drag Claim No into the Repeater Table from Table2.
Make the Boxtype of ListColumn Title to None.
concat the strings comma and colan by editing the data items.