subhash5678
Programmer
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
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