>Query is not reference in the DE. The documentation states that the report would use the open cursor and gives a similar example to mine. The table is not explicitly referenced in the DE or the report either.
>
>I do agree that the report seems to be using the table and not the cursor but don't understand why one report can access the table when the other report can not. The table is opened for querying and there should be no exclusive lock on the table.
>
>How do I reference Query in my DE if it only exists temporarily?
>
>In my new reports generated with the wizard, the physical table is in the DE. What causes them to generate in the correct sort order in each case? And can I modify this sort order later without using the wizard?
>
>Gordon

Most of my reports have an empty DE. I generate the cursor just prior to the REPORT command, simular to what you posted.

Excuse me if I'm being too basic here but bear with me...

Check the "expression" on any of the report controls. (Double-click on one of them) Is the Table Name i.e. Games present or is Query? I'm betting on the table name. If so, you have 2 choices. (at least <BG>):

1) Change the expressions to use Query.
2) Skip the SQL and use the table with the order you want prior to the REPORT command.
3) Skip the SQL and add the table to the DE with the order you want.
HTH,