Splitting a query into rows

Epicor ERP 10
,
1

Hi

I have a report that returns some time in / time out data and currently the results are on a single row but i need to separate the rows to ‘IN’ on one row and ‘OUT’ on the next.

what is a good way to approach this in a BAQ?
currently i have

1234 14/03/2024 05:00 12:00
1234 14/03/2024 13:00 16:30

What i need
1234 14/03/2024 05:00
1234 14/03/2024 12:00
1234 14/03/2024 13:00
1234 14/03/2024 16:30

thanks

2

I managed to achieve what i needed, i moved the field to the TOP and set that as my IN row then created a sub query for the OUT row and did a union

1 Like