• Report Designer - Group by one, Sort by another

    I want to create a SOPS report Outstanding SOPS Grouped by Sales Order Sorted by Due Date (Sales_Order.Despatch_Date) I've tried using a standard report; however, I can't seem to change to details to allow both grouping of items by order number…