use client set order to "LastName" report form ClientList... usethe first command will close whatever table was open in the currently selected work area.
use client in 0 && Note the in 0 part - it opens table in the first free work area leaving other tables opened set order to LastName report form ClientList... useBut in general, it is better to work with cursors:
select * from Client; order by LastName, FirstName; into cursor TempReport report form ClientList... useIn this case, the report should have no tables in its DataEnvironment.