I have been able to create a very nice Excel layout for “Received - Not Yet Invoiced” in the Order Report form. I have used the Filter, the Options, the Columns etc. It works fine but the Finance department wants the data sorted.
Is there any way to add something equivalent to “ORDER BY” in SQL or a multi-level sort in Excel? I have tried the multi-level sort from Excel in my layout but it does not work in the report once the data is populated.
Any suggestions are welcome.