Summary over Char field

[subhash5678]

Hi,

Can anybody let me know if there is any summary function to concatenate a character values in a row.

For example, I have the data similar to that given below:

Sample Data: Contract_ID Product_ID
1 ABC
1 DEF
2 GHI

I have to show all the product_id seperated by a comma in one row for each contract_id. I have to show the results in the report as follows:

Contract_ID Products
1 ABC, DEF
2 GHI

Can anybody help me in doing this?

Thanks

 

[CognosTechUser]

This must be done at the database level using a stored procedure.