Sorting

Hi All, I’ve got a report with Sales Header and two indented tables: Sales Line and Shipment Line. The idea is to give an overview of all the lines in Sales Line and Shipment Line sorted on the Shipment Date. Sales/Shipment Lines originating from the same Sales Header may have different Shipment Dates. How can I get this sort order right? Obviously with Sales Header as “top” record, Navision first selects the Sales Lines, prints them and loops through the Shipment Lines next. And because some other sorting information is in the Header, I have to start from it. Of course I could use a temp table, but temp table definitions are spreading like wildfire in our database and I would like to prevent another one. Any suggestions?