Summarize into a single line for Dashboard/BAQ

[NateS (Nate Schoonover)]

Sorry I don’t know anything about progress or v9. I expect you can still build a BAQ similar to this. However yo may not be able to use the string agg function. Before string agg there was “for xml path”. Perhaps this could be your solution!

BAQ: Calculated Field Concatenate Rows to single field

Is there a function/query that will allow multiple returned rows to be combined into a single field? I’m looking thru the PO Tables and finding all PO numbers for a specific job. The job may have 3 POs. PO Number : Job Number 70001 : 00245 70010 : 00245 70008 : 00245 I want to combine/concatenate these to be something like Job Number : PO Numbers 00245 : 70001,70010,70008