Perhaps I can get a little feed back to help me with what I am doing here.

It is required that I give my end user's access to the VFP Report Designer. Having said that, all the data is prepared by SELECT-Sql into a table before the report is to be printed/viewed/modified. So, the reports will be based on one table.

This brings up the first question-problem. If I SELECT-Sql into a Cursor, as expected when the report is being Modified there are no tables listed in the expression dialog (I realize I can use SCATTER MEMVAR MEMO to get field names). I have no table in the report DE, and Set AutoOpenTables and AutoCloseTables to .F. Although it is possible to modify a report like this, I can't ever get it to Preview while the Report Designer is up, as it always ask for a table. So - this means you can't preview the changes you made to the report. However, if I am not modifying the report, they do print-preview normally. Am I missing something here? The cursor that holds the table is the currently selected table when I bring up the Report Designer (although it doesn't seem to know this).


This brings up the 2nd question-problem. If I SELECT-Sql into a Table (instead of a cursor) titled say 'MyTable' - and I have:
1-added in each Reports DE the MyTable
2-Set AutoOpenTables and AutoCloseTables to .T.
and I allow the user to MODIFY REPORT 'ThisReport' within the application, the Report Designer pretty much works like I would expect it to except when attempting to Preview. Within the running application, if you select the Preview button on the toolbar or in the File menu... it give the VFP error:

"RETURN SYS(1500, m.cBar, '_MFILE')"
Function is not implemented.

I have been told this is a VFP error. Can someone tell me how to work around this?

To sum all this up, I would appreciate how others tackle this problem when it is required that you give end user's the ability to use the Report Designer within an application.

Thanks for the help.

Mel Cummings