The Index Tags etc. are irelevant because you should be running the report with the result of the query in the data environment. What tables are open in the DE?
Do the fields in the report relate to the qery (as in "query.game" etc. ) or to the table (as in "bball.game")
I think you are running the query and then reporting from the table - is it possible?






>I inherited two reports one in Game sequence and the other in Team sequence.
>
>Game>>
>SELECT BBALL.Game,BBALL.Team,BBALL.Class;
> FROM BBALL.DBF BBALL;
> ORDER BY BBALL.Game, BBALL.Team ;
> INTO CURSOR Query
> REPORT FORM game.frx PREVIEW IN SCREEN
>
>Team>>
>SELECT BBALL.Game,BBALL.Team,BBALL.Class;
> FROM BBALL.DBF BBALL;
> ORDER BY BBALL.Team, BBALL.Game ;
> INTO CURSOR Query
> REPORT FORM team.frx PREVIEW IN SCREEN
>----
>Database structure
>Game character 25 indexed
>Team character 20 indexed
>Class character 20 indexed
>....
>EVENTNO numeric non-null indexed
>The table data entry is in EVENTNO sequence
>-----
>







>Both reports fail to generate in correct order.
>
>Preview of similar report generated with Report Wizard are in correct order
>without ORDER BY.
>
>Group header is Game for one report and Team for the other report.
>
>Is there a trick to this? Also, the Team report kept on indicating 'file in
>use' even after re-boot. There is very little difference in the report
>designs. This problem disappeared when I created a new Team report from the
>Game report. Anyone explain what is going on?
>
>Gordon