>>Hi Denis,
>>
>>It sounds like some other cursor/table is open in the current work area. Not the one you expected. It may happen if you're running report from the form with grid on it. See Forms with Grids and printing reports FAQ #15515.
>
>Thanks for the tip Sergey but in my case no grids on the form and the only processing happening is what I described earlier. SELECT-Sql followed by a cursor built programmatically.

Hi Denis,

I still belive that you're on the wrong work area when you run your report. To verify that you can add field with expression ALIAS() to your report and run your report with code that didn't work properly.