Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cancel if no data - not print blank page
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Cancel if no data - not print blank page
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01423464
Message ID:
01423464
Views:
99
I have a report that gets called after a certain process (printjob from an activex control). This all works good. Now we've are added a flag to the system that determines which records will be available for this report, basically a filter. Based off the flag, we determine which SQL Stored procedure to run.

I'm calling the stored procedure to get the data from the BeforeOpenTables method in the report (VFP8). If the query doesn't bring back any records, it still prints out a blank sheet. Is there a means to cancel at this point so the blank sheet does not get printed?

Thanks

Kirk
Next
Reply
Map
View

Click here to load this message in the networking platform