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?
Try with Listagg() function in SQL. You will get it.