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?
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.