Hi,

No, I don't use the data envirionment as I explained. However, I did find out what was wrong. It was kind of weird.

The underlying form has a resize event, that queried a table. This means that the work area changed when it was resized. However, the strange thing is that the resize event of the underlying form fired when I resized the preview window!!! So, therefore the report no longer displayed. Not only that, this new alias was stored in the Foxuser, so after that anytime I ran the report he changed workarea automatically!

Now I have used the old

lcAlias = ALIAS()
... code
SELECT &lcAlias

in the resize event, so it is now OK.

Steven

>Do you use report data environment(DE) or not? Does report DE contain tables or cursors?
>
>>Hi,
>>
>>I am using a report with a cursor extracted from a query. As the cursor doesn't exist exept in runtime, I cannot add it to the data environment of the report.
>>
>>I select the cursor before I run the report, and it works well. However, when I resize the preview window, the program jumps to another existing table. As the table now is not the current table, I have problems displaying the report properly.
>>
>>How can I get around this? How can I get the correct cursor to remain the current cursor?
>>
>>Steven