>>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??
>
>Maybe range clause is sufficient for you?
>
REPORT FORM MissingRxNumbers range 1, MAXNUMTOPRINT
Cetin
Or NEXT MAXNUMTOPRINT if a number of records is even a better measure.
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.