How do you change a sql query in a report without re-doing the report. Using 10.2 with Visual Studio Pro 2005. You can show sql query but I don't see how to change without starting over. I also tried to base a report on a sql view(query) but it seemed not to pickup all the elements of the view like multiple by order parameters.

We are using MSSQL 2005. I'll try the command text route. I am using Groups. It is a company directory based on a SQL table and the grouping is by store, which we have 31 of them. The order would be within the store group; department, display order, name where you could force a name high like a manager of a department by setting a display order that overrides the alpha name sort.