Kurt: That's exactly what _PAGETOTAL does: it triggers the reporting engine to run the report one time invisibly and populate the _PAGETOTAL variable. Of course, this can wreak havoc if you've snuck a couple of UDFs in the snippets!
On Mon, Mar 27, 2017 at 1:37 PM, Kurt Wendt <[email protected]> wrote: > The problem as I see it - is how can VFP predict full length of the report at > the start? Many things are dependent on the data - even to the point of > things like starting a new grouping on a new page - which could cause a gap > at a bottom of a page. Unless, of course, VFP can internally run the report > without you seeing it - in like a 1st pass - so that it can properly > determine total # of pages! Anyway - those are my thoughts on the matter... > > Although - truthfully - I have even done much in the way of reports for > years. The one system I worked on here had "reports" - but, they were ALL > just Excel files. The other system I still currently support - it has reports > - but, they just work and have not needed ANY Modifications in the past > nearly 2 years since I have been support this system. > > Regards, > Kurt Wendt > Senior Systems Analyst > > > Tel. +1-212-747-9100 > www.GlobeTax.com > > > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of Richard > Kaye > Sent: Monday, March 27, 2017 1:24 PM > To: [email protected] > Subject: RE: VFP9SP2 report error with _pagetotal variable > > [Page ]+ALLTRIM(TRANSFORM(_pageno))+IIF(_pagetotal>1,[ of > ]+ALLTRIM(TRANSFORM(_pagetotal)),[]) > > This is the expression I use. I can't recall seeing it misbehave. > > -- > > rk > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of Ted Roche > Sent: Monday, March 27, 2017 1:21 PM > To: [email protected] > Subject: Re: VFP9SP2 report error with _pagetotal variable > > The MSDN suggests your string to print it is too complicated to parse and > recognize that _PAGETOTAL is being invoked, and to force VFP to run the > report in two-pass mode. The IIF() near the end of the article should resolve: > > https://msdn.microsoft.com/en-us/library/aa977060(v=vs.71).aspx > > HWP's What's New in VFP8 also has some good suggestions. > > On Mon, Mar 27, 2017 at 1:10 PM, > <[email protected]> wrote: >> On 2017-03-27 13:10, Richard Kaye wrote: >>> >>> How do you have REPORTBEHAVIOR set? >> >> >> >> I tried it with 80 and 90, both. Same problem. >> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4v9dee_gtfcd_pzc5wqardtqltjzcq5grgp8itbf3e...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
