Dynamics Community Forum Thread Details

BOM Report - When Printing Multi-Level BOM Report.. Sort Order Question

Does anyone know how to alter the Multi-Level BOM Report, using the Report Modifier, to sort the order of the BOM items so they will display on the report tree-style fashion? For further clarification on my question: If you look at an item's BOM structure on the Bill of Materials screen and expand all the nodes, this is what I'm trying to make the Multi-Level Report to print out like. The report definition's original sort order has no sort order specified.

I tried using PositionNumber, Level0, and PositionNumber2 in different orders but I can't seem to achieve the desired results using this combination of sort fields. As of right now, it's looking slim that this is going to be possible due to the limitations on sorting in the Report Modifier.

Thanks in Advance

**Update** I changed the key to the following and it worked well enough for what we needed. Any level after the 1st level in the BOM sorts by item number, so I'll leave this post open in case someone figures out how to sort all levels by their position number in the Report Modifier.