Data Sorting and Ordering

Alex_de_Kock

Good day All

Hope you can assist.

I have a complicated dataset which contains data from 01/03/2012 to date. This data is then summarized by the specific stock items, and grouped into the specific stock departments inside a report page.

I need to sort this summarized data by the sum of (<Query1."SalesQty"> - <Query1."SalesRetunsQty">) Descending.

This cannot be done inside my query, as I will then lose the functionality of searching for data in a specific date range, for eg. (01/05/2012 to 31/07/2012).
My query thus contain each and every transaction pertaining to all the stock items, which is then necessary to do the correct summary on the ReportPage.

Hope someone can come up with a solution? :-)

Thank you in advance

gpi

wrote:

This cannot be done inside my query, as I will then lose the functionality of searching for data in a specific date range, for eg. (01/05/2012 to 31/07/2012).

Use additional query for searching