views:

3

answers:

0

In Report Builder 3.0, you can open a report, or a query. When you open up a query, you're in a full-screen visual query designer.

I cannot figure out how to indicate that I want to sort columns in this designer. There is an "Edit as Text" mode. When I go in there, it shows the SQL statement. I can add an ORDER BY clause at the end, and when I run the query, this works fine.

However, once you edit a query in "Edit as Text" mode, you cannot switch back to the visual designer. When you try, it tells you that you'll lose the changes you made to a changed query, or the whole SQL statement to a saved "Edit as Text" query. And sure enough, you do!

Did I miss something, or is there really no way to indicate a sort for a query in the Report Builder 3.0 visual designer?