Create delimited list of part numbers from invcdtl

Kinetic ERP
1

BAQ Designer - I would like to create a calculated field that will show a delimited list of part numbers for a InvcHead as input. I.e. for each Invoice number - i would like a calculated field to show a delimited list of the part numbers on that invoice.

Is this possible in the BAQ Designer? I know i can do this in SSRS however, i would prefer to do it in the BAQ.

Any help greatly appreciated.
DaveO

2

Yes, absolutely! You can use String_Agg() to combine the results of a subquery into a single calculated field. See the attached simple example.
InvDtlParts.baq (25.9 KB)

1 Like
3

Mr. Nate: Thankj you for the example i will give that a try.

DaveO

4

Mr. Nate: You are a genius - that works perfectly.

Thank you so much,
DaveO

1 Like