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