I have a report which is grouped by user_id. When I checked the SQL query for the report, it did not have any group by clauses but had a order by clause for the user_id. Now I want it to order by sales_date. I don't know how to add that to the report. So I added that manually into the SQL query and it worked fine but the saved changes to the SQL query did not show up at the next run of the report. Can someone tell me how to add the extra order by clause and save the cjanges so that the report reflect the changes at the next run.