Sorting by Sequence number in a CR report(or other reports) would be very useful to have as it would help maintain the BOM structure of an assembly. Currently our reports are sorted by Item number only which does not maintain any BOM structure.
Ideally what we want is sorted by sequence number first and then within that sort sort by Item number. This can be done in the web app via configure sort but because sequence number is not a field available in the jasper reports we cannot sort by sequence number.
![image (3).png image (3).png](https://forums.autodesk.com/t5/image/serverpage/image-id/1099906i89ED7C5CD75A79AE/image-size/medium?v=v2&px=400)
The export to excel function exports out the sequence number so we can use that for grouping sub assemblies but the jasper reports do not.