Home › Forums › BIRT Reports › Combine multiple row with 1 field Tagged: #BIRT#SQL#MultipleRow#SingleField This topic contains 1 reply, has 2 voices, and was last updated by Peter 4 months, 1 week ago. Viewing 2 posts - 1 through 2 (of 2 total) Author Posts 14th May 2018 at 7:58 am #418 vinaysaraswatParticipant There is a table with an order# field (KEY) and a description field. I need to combine the description fields, to make it only one record for all of the description entries and one order#. can anyone suggest how this can be done in SQL and works in BIRT? I tried with group_concat and a few others but it none of them worked. Order# Description 728123 WHITE 728123 35.00X45.00 728123 EXTRA 728123 SANDBLASTED OUTTER 728123 CHARCOAL FLAT 728123 SP 728123 BT 728123 NO GLAZE 728123 EXTRA STICKS 728125 WHITE 728125 56.00X24.00 I’m using a DB2 as400 database. Kindly help me out with the solution. Thanks, Vinay 16th May 2018 at 5:54 am #419 PeterParticipant Hello Vinay, Try with Listagg() function in SQL. You will get it. Thanks, Peter Author Posts Viewing 2 posts - 1 through 2 (of 2 total) You must be logged in to reply to this topic.