I have a report based on a select query. Within the query there is a "start date" and an "end date". I have sorted the start date to ascending. When I run the qury it executes it correctly with the start date in ascending order with the other data correctly shown.
However, when I preview the report, it shows the answers unsorted, ir the date is not sorted in ascending order. Any ideas why this should be the case?