Sorting in report

[lefty2cox]

I have a simple invoice report I created that is based on a query. In the query, I'm soring by date. But for some reason, the report doesn't. It sorts in the order that the records were entered. I'd like the report to also sort by date. I should probably add that the query is based on a table that is sorted by date. I'm not sure why the report isn't following suit.

Thank you.

[mike60smart]

Hi

In the properties of the Report set the Order By as follows:-

[Welshgasman]

Reports take no notice of source sorting

It is all done in the report, in sorting and grouping.

[lefty2cox]

Thank you very much

[dizy8]

Hi Mike!

Thank you very much for this! this solve my problem!

Thank you!

[mike60smart]

Glad to help

[June7]

Actually, report can comply with ORDER BY in query but only for very simple reports. I just tested this in a new report and sort was applied, even on date DESCENDING. I tried same query as source for an older report which really looks just as simple and the sort isn't working.

So wouldn't rely on it, use report design features to set sorting.