Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report Preview / Print from a Cursor
Message
From
10/03/1999 01:12:59
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Report Preview / Print from a Cursor
Miscellaneous
Thread ID:
00195721
Message ID:
00195721
Views:
48
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
Next
Reply
Map
View

Click here to load this message in the networking platform