How do you have REPORTBEHAVIOR set?
--
rk -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Kurt Wendt Sent: Monday, March 27, 2017 1:07 PM To: profoxtech@leafe.com Subject: RE: VFP9SP2 report error with _pagetotal variable
Mike - I believe this is a VERY Common problem and has been covered here on the forum a number of times over the years. As I know I had the problem in the past as well. I don't think VFP can truly generate the total page count until AFTER the report is completed. So - what people have suggested in the past - which I think I did once - is to run the report Twice. The 1st time around it will generate the total # of pages. Then you capture that value and then USE it when printing the actual report the 2nd time. Maybe something like the 1st time around the report is generated but goes to a PDF file or something like that. Although - that part is just a WAG on my part...
Regards, Kurt Wendt Senior Systems Analyst
Tel. +1-212-747-9100 www.GlobeTax.com
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of mbsoftwaresolutions@mbsoftwaresolutions.com Sent: Saturday, March 25, 2017 11:39 PM To: profoxtech@leafe.com Subject: VFP9SP2 report error with _pagetotal variable
See https://www.screencast.com/t/8bj9GNQk for what's happening. Outermost group is CUST_ID. In Report Writer, Data Grouping tab, I've selected Group starts on NEW PAGE NUMBER 1 (the last radio option). I must admit I've never used this option before; most of my reports are always the New Line or New Page option.
I'm using this expression in my footer to produce what you see: "Page " + allt(str(_pageno)) + " of " + allt(str( _pagetotal))
Obviously the _pagetotal internal variable is not getting set correctly.
Ideas on how to fix? tia! --Mike
[excessive quoting removed by server]