Instead, select into a cursor then close the cursor after the report. Or put your select statement into the init of the report's DE. This way all of the code to create the report is together.

>I normally using a SQL to sort out the data and output to a table, eg
>
> SELE A,B,C From abc.dbf FOR A={01/01/1999} INTO TABLE temp
>
>,and then run the report.
>
>I feel that this is not a good way.
>
>Can anyone can tell me the better way.
>
>Thank u.