With VFP9 this would be easier... Anyway, with VFP8 you
Report ... NOCONSOLE
if _PAGETOTAL<100
Report ... to printer
else
Messagebox('Bad select statement')
endif
>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??