Hi Guys,
I have an invoice report that I need the line items to list in a specific order, which I have created in the query for the report.
As part of the report, the line items are totalisedin hidden field in the footer of the line items report and having these totals, the sorting I have placed in the query is ignored?Code:=SUM(lineitems)
Can anyone advise if they have found this and how I can resolve this.
Thanks in advance