ProFoxers,
I have a report. It has 2 groups and I'm using a page x of y object in the page footer. I want the page numbers to reset on the outer group. I've set the appropriate setting in that group. With the particular data set I am testing with, the first group only has one page worth of data. All the rest of the groups have up to 2 pages of data. However, the x of y object shows 1 of 2 for the first group and I'm expecting 1 of 1. As I continue to poke at this I figured why not throw out an actual VFP question to the collective wisdom.
Happy Friday!
--
rk
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
The plot thickens. I tweaked my data set so that the one page group at the beginning went away, and I allocated those records to a group in the middle of the data set. That group now runs to 3 pages but the _pagetotal system var still shows 2 so I get the mathematically incorrect Page 3 of 2 for that group. So I'm guessing I can't really do this if I want to rely on _pageno and _pagetotal... (Paging Cathy Poutney... <grin>)
--
rk From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Richard Kaye Sent: Friday, August 12, 2022 12:39 PM To: profoxtech@leafe.com Subject: Report page number resets by group using page x of y expression
ProFoxers,
I have a report. It has 2 groups and I'm using a page x of y object in the page footer. I want the page numbers to reset on the outer group. I've set the appropriate setting in that group. With the particular data set I am testing with, the first group only has one page worth of data. All the rest of the groups have up to 2 pages of data. However, the x of y object shows 1 of 2 for the first group and I'm expecting 1 of 1. As I continue to poke at this I figured why not throw out an actual VFP question to the collective wisdom.
Happy Friday!
--
rk
I know I've seen this before. You might search the Profox archives for _pagetotal. I seem to recall a problem with runtimes/hotfixes not applied that would cause _pagetotal to misbehave.
On Fri, Aug 12, 2022 at 12:47 PM Richard Kaye rkaye@invaluable.com wrote:
The plot thickens. I tweaked my data set so that the one page group at the beginning went away, and I allocated those records to a group in the middle of the data set. That group now runs to 3 pages but the _pagetotal system var still shows 2 so I get the mathematically incorrect Page 3 of 2 for that group. So I'm guessing I can't really do this if I want to rely on _pageno and _pagetotal... (Paging Cathy Poutney... <grin>)
--
rk From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Richard Kaye Sent: Friday, August 12, 2022 12:39 PM To: profoxtech@leafe.com Subject: Report page number resets by group using page x of y expression
ProFoxers,
I have a report. It has 2 groups and I'm using a page x of y object in the page footer. I want the page numbers to reset on the outer group. I've set the appropriate setting in that group. With the particular data set I am testing with, the first group only has one page worth of data. All the rest of the groups have up to 2 pages of data. However, the x of y object shows 1 of 2 for the first group and I'm expecting 1 of 1. As I continue to poke at this I figured why not throw out an actual VFP question to the collective wisdom.
Happy Friday!
--
rk
[excessive quoting removed by server]
Thanks. Ted. Will try that.
Pretty sure I'm on the properly patched versions but there might be a manual APP update I've missed.
--
rk
From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Ted Roche Sent: Monday, August 15, 2022 1:46 PM To: profoxtech@leafe.com Subject: Re: Report page number resets by group using page x of y expression
I know I've seen this before. You might search the Profox archives for _pagetotal. I seem to recall a problem with runtimes/hotfixes not applied that would cause _pagetotal to misbehave.
On Fri, Aug 12, 2022 at 12:47 PM Richard Kaye <rkaye@invaluable.commailto:rkaye@invaluable.com> wrote:
The plot thickens. I tweaked my data set so that the one page group at the beginning went away, and I allocated those records to a group in the middle of the data set. That group now runs to 3 pages but the _pagetotal system var still shows 2 so I get the mathematically incorrect Page 3 of 2 for that group. So I'm guessing I can't really do this if I want to rely on _pageno and _pagetotal... (Paging Cathy Poutney... <grin>)
--
rk From: ProfoxTech <profoxtech-bounces@leafe.commailto:profoxtech-bounces@leafe.com> On Behalf Of Richard Kaye Sent: Friday, August 12, 2022 12:39 PM To: profoxtech@leafe.commailto:profoxtech@leafe.com Subject: Report page number resets by group using page x of y expression
ProFoxers,
I have a report. It has 2 groups and I'm using a page x of y object in the page footer. I want the page numbers to reset on the outer group. I've set the appropriate setting in that group. With the particular data set I am testing with, the first group only has one page worth of data. All the rest of the groups have up to 2 pages of data. However, the x of y object shows 1 of 2 for the first group and I'm expecting 1 of 1. As I continue to poke at this I figured why not throw out an actual VFP question to the collective wisdom.
Happy Friday!
--
rk
[excessive quoting removed by server]
And it looks like Cathy covered this in the Making Sense of Sedna book; clues discovered by following the advice of Ted “Did you do your homework here before you asked your question here?” Roche. 😊
--
rk
From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Ted Roche Sent: Monday, August 15, 2022 1:46 PM To: profoxtech@leafe.com Subject: Re: Report page number resets by group using page x of y expression
I know I've seen this before. You might search the Profox archives for _pagetotal. I seem to recall a problem with runtimes/hotfixes not applied that would cause _pagetotal to misbehave.
On Fri, Aug 12, 2022 at 12:47 PM Richard Kaye mailto:rkaye@invaluable.com wrote:
The plot thickens. I tweaked my data set so that the one page group at the beginning went away, and I allocated those records to a group in the middle of the data set. That group now runs to 3 pages but the _pagetotal system var still shows 2 so I get the mathematically incorrect Page 3 of 2 for that group. So I'm guessing I can't really do this if I want to rely on _pageno and _pagetotal... (Paging Cathy Poutney... <grin>)
--
rk From: ProfoxTech mailto:profoxtech-bounces@leafe.com On Behalf Of Richard Kaye Sent: Friday, August 12, 2022 12:39 PM To: mailto:profoxtech@leafe.com Subject: Report page number resets by group using page x of y expression
ProFoxers,
I have a report. It has 2 groups and I'm using a page x of y object in the page footer. I want the page numbers to reset on the outer group. I've set the appropriate setting in that group. With the particular data set I am testing with, the first group only has one page worth of data. All the rest of the groups have up to 2 pages of data. However, the x of y object shows 1 of 2 for the first group and I'm expecting 1 of 1. As I continue to poke at this I figured why not throw out an actual VFP question to the collective wisdom.
Happy Friday!
--
rk
[excessive quoting removed by server]
_______________________________________________ Post Messages to: mailto:ProFox@leafe.com Subscription Maintenance: https://protect-us.mimecast.com/s/rTsECzpBE7uvZxAso0ass?domain=mail.leafe.co... OT-free version of this list: https://protect-us.mimecast.com/s/rEH3CADQ2MIMXnzsMpXXC?domain=mail.leafe.co... Searchable Archive: https://protect-us.mimecast.com/s/EVKnCBB82Pu3rMOhv_ewn?domain=leafe.com This message: https://protect-us.mimecast.com/s/VhYpCDkY2QSQznkhBv9tZ?domain=leafe.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.
-
Richard Kaye -
Ted Roche