[SOLVED] Group multiple results into one line

Epicor ERP 10
1

Hi all,

I have a simple BAQ that displays the operations (and other job details) on a job. On the example attached, there are 5 operations, therefore the BAQ displays 5 lines.
Is it possible to modify this where there will be only one line per job, and one column that shows all the operation sequences and/or another column that shows all the operation codes?

Thanks for your help.

Hymal7

image
image.png800×512 22.3 KB

2
3

Thanks for the link @ckrusen

4

I used it for a BAQ that groups together Order lines with the same Product Group.

The upper pane is summary (Lines with the same Product Group on the same order), the lower shows the individual lines.

image
image.png709×364 36.7 KB

5

Thanks @ckrusen finally got it working…however I still get a comma at the end of the results. do you know how to get rid of it?

image

6

I think I made a calculated field that took that value and just trncated it if the last character was a comma.

Case when substring(Lines, len(Lines), 1) = ',' then substring(Lines, 1, len(Lines)-1)  else Lines end;

Lines is the field that holds the comma sep text.

7

thanks this worked ! (P.S. added “end” at the end of the code)

8

Hi Hymal7, Do you mind sharing you JobHead, JobOper BAQ? Thanks