same query is used in Form and Report.
Your code is working on filter but not in sort, when I sort data and take report the report, the report is not in Ascending order.
I don't know how to upload the file in this forum, otherwise I upload my file for you ease.
Please check where I'm going...