Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Suppress Printing of Report if too many pages to print
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Suppress Printing of Report if too many pages to print
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01359156
Message ID:
01359156
Views:
75
Hi Gang!

Today's Question.....

I have a report that can go nuts if the conditions are right, and print hundreds of pages of useless data..... sorry, it comes with the territory of some garbage data possibly being in the users tables.

This report can print at night in a batch file. So, you see I don't want this to print IF the number of pages is too large (usually, it would only be 1 page... BUT.... you never know....).

So....

Given the name of the report is MissingRxNumbers and the Maximum Number of pages to print is MAXNUMTOPRINT, how would you go about coding this.....

I assume you have to run the report once to get _PAGETOTAL, then something like this..

IF _PAGETOTAL >= MAXNUMTOPRINT
THISFORM.m_StoreTooManyPageInfoInAuditTable
else
REPORT FORM MissingRxNumbers
endif

What would be the correct coding here??
Tommy Tillman A+ NetWork+ MCP
Next
Reply
Map
View

Click here to load this message in the networking platform