Report not in same order as Query?

Hello all,

My report is a listing of people using the following info:
FIRSTNAME LASTNAME TITLE GROUPNAME

Not everyone in a group has a title - but if they do, I want them to appear first in each sub-group (GROUPNAME).

So I wrote a query that says: "SELECT blah blah FROM TABLE1, TABLE2, TABLE3 ORDER BY TABLE2.GROUPNAME, TABLE3.TITLE DESC , TABLE1.LASTNAME;

When I preview the query, the results appear exactly as I want - however, when I preview the report it looks like the order by was overwritten because now it is still ordered and group appropriately, but everyone in the subgroup is ordered by LASTNAME - as if the TABLE3.TITLE DESC was ignored.

Anyone know what could be causing this? Is there a limit to the amount of ORDER BYs that you can use in a report?

Thanks!

-Sean

The best way to order a report is by using the Sorting and Grouping button on the toolbar because, as you say, it doesn't always follow the sorting order from the base query.

That sure did it - Thanks DBL!

-Sean

The ONLY way to reliably order a report is to use the report's sorting and grouping dialog.