I generally run reports by creating a cursor, then running it through REPORT FORM PREVIEW and a report file (.FRX).
I have one report that (almost all the time) shows the first page of the report in the PREVIEW, but any attempt to go to the next page, or print it, causes a "Variable not found" error. The "variable name" is always the name of one of the columns in the driving cursor.
The cursor is created by a somewhat involved process of SELECTs on SELECTs. I have tried several things, which don't help:
1. Re-created the report .FRX from scratch
2. Included the NOFILTER clause in all SELECT - SQL statements to force creation of a physical file.
3. Tried putting the cursor creation code in the INIT() method of the report DataEnvironment.
This is a really annoying problem - I can insert a BROWSE immediately before the REPORT FORM PREVIEW, and the driving cursor is there and perfect. But it won't print or preview properly.
The problem also occurs with a straight REPORT FORM TO PRINT rather than PREVIEW.
Any help or ideas greatly appreciated.
Regards. Al
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up