Group or split records based on a field value Electronic reporting

(0) Share

Report

Posted on by Huggins Mafigu

511

Hi folks,

I have a requirement to print order items that are being delivered to the same address on a different page. For example, if an order contains 25 lines and all those items are spread across 5 different delivery addresses, the output should be 5 pages with 5 line items each. For example, items that are being delivered to the Delivery Address 1 will be on the same page, and so on.

What I'm struggling with now is to have items that belong to the same delivery address on the same page. I tried to use Group By, Split, SplitList, and Enumerate but I was only able to get the order items for all that are being delivered to the first delivery address in the list.

Any help is appreciated.

I have the same question (1)