Dynamics Community Forum Thread Details

Standard Prod. Order Picking List not sorting by Line No. after customization

I copied the standard “Prod. Order – Picking List” report and made a small customization.

The standard report structure is:
Item
└─ Prod. Order Component

I want the report to print Production Order Components in Line No. sequence

(i.e., components sorted by Line No. within each Production Order).

Change attempted

In the copied report, I added sorting to the child dataitem:
DataItemTableView = sorting(Status, "Prod. Order No.", "Line No.");

I also tried:
sorting("Line No.")

Issue

Even after applying the above sorting:

The report does not print components in Line No. order
The output order is inconsistent when:
- Multiple Items exist
- The same Production Order has multiple components
- Debugging shows that sorting is already incorrect at the AL dataset level
RDLC has no additional grouping or sorting

Question

Is this a known / expected limitation of AL reports when using Item as the parent dataitem?
Is there any supported way to enforce global sorting of Prod. Order Component by Line No. while keeping Item as the parent
Is the recommended approach to:
- Redesign the report to use Production Order as the parent, or
- Collect data into a temporary table and print from there