Hi all,
So at the bottom of a report I can put a field that says:
' - Page ' +trans(_pageno) + ' of ' + trans(_pagetotal)
But if I want to set the page number to reset back to 1 whenever the
datagroup DRIVER changes, how do I do that?
_pagetotal is no longer valid and I get things like Page 3 of 2.
TIA,
Tina
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/096901cbfe96$21a7b6a0$64f723e0$@com.au
** 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.
On Tue, Apr 19, 2011 at 3:31 PM, Tina Currie <tina@datahouse.com.au> wrote:
> Hi all,
>
>
>
> So at the bottom of a report I can put a field that says:
>
>
>
> ' - Page ' +trans(_pageno) + ' of ' + trans(_pagetotal)
>
>
>
> But if I want to set the page number to reset back to 1 whenever the
> datagroup DRIVER changes, how do I do that?
>
>
>
> _pagetotal is no longer valid and I get things like Page 3 of 2.
>
>
>
> TIA,
>
>
>
> Tina
>
>
> Data grouping -> reset page to 1 for each group
>
A+
jml
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/BANLkTin-0ew5XSjgojRHtgkf-FPqSFe81g@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.
Maybe spilt the report across multiple groups :-
for ncnt = 1 to 10
set filter to DRIVER=ncnt
report form MyRep to file "dummy.txt" noconsole
_Pagetotal=_pageno
report form MyRep to printer prompt noconsole
endfor
Or something like that ...
--
Stephen Weeks
stephenweeks@fastmail.fm
--
http://www.fastmail.fm - One of many happy users:
http://www.fastmail.fm/docs/quotes.html
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/1303228690.16893.1442913773@webmail.messagingengine.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.
Thanks Jean - I had already tried that and while it sets _pageno back to 1
for each group, the system variable _pagetotal is not valid for the amount
of pages for that group.
Tina Currie
DataHouse
0414 576 453
www.datahouse.com.au
>
> Data grouping -> reset page to 1 for each group
>
A+
jml
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/09ba01cbff0c$127e7940$377b6bc0$@com.au
** 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.
Author: Stephen Russell
Posted: 2011-04-20 09:31:25 Link
On Tue, Apr 19, 2011 at 10:36 PM, Tina Currie <tina@datahouse.com.au> wrote:
> Thanks Jean - I had already tried that and while it sets _pageno back to 1
> for each group, the system variable _pagetotal is not valid for the amount
> of pages for that group.
--------------------------------
The variables for the report can handle what you want. There is a
reset option and that is what you are probably not setting.
Make a var for GroupPageCount and reference that in the footer.
--
Stephen Russell
Unified Health Services
60 Germantown Court
Suite 220
Cordova, TN 38018
Telephone: 888.510.2667
901.246-0159 cell
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/BANLkTinNVRY=8EgmWtL+zBzfV3X0JtS+-w@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.
*------------------------------------------------
>From "Making Sense of Sedna & Visual FoxPro 9 SP2
*------------------------------------------------
Using the fxResetPageTotal class
The way this feature works is a little odd, but it looks for the existence
of a public variable called _ResetPageTotal. If it finds this variable, it
takes that to mean you want it to track page counts and totals, which also
means a two-pass run of the report is required. During the processing of the
report, the first pass gathers the total number of pages for each data
group. During the second pass, the _ResetPageTotal variable is updated at
the beginning of each data group with the appropriate page count previously
gathered for the data group. This means you can use the _ResetPageTotal
variable on your report to get the total number of pages in a data group. In
other words, if you want to print Page X of Y relative to the data group,
use the following expression in your report.
"Page " + TRANSFORM(_PageNo) + ' of ' + TRANSFORM(_ResetPageTotal)
There's all kind of reporting "goodness" in this book.
/SET SHAMELESS PLUG OFF/
Cathy Pountney
> -----Original Message-----
> From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com]
On
> Behalf Of Tina Currie
> Sent: Tuesday, April 19, 2011 9:32 AM
> To: profoxtech@leafe.com
> Subject: Page Numbers - Data Grouping in Reports
>
> Hi all,
>
>
>
> So at the bottom of a report I can put a field that says:
>
>
>
> ' - Page ' +trans(_pageno) + ' of ' + trans(_pagetotal)
>
>
>
> But if I want to set the page number to reset back to 1 whenever the
> datagroup DRIVER changes, how do I do that?
>
>
>
> _pagetotal is no longer valid and I get things like Page 3 of 2.
>
>
>
> TIA,
>
>
>
> Tina
>
>
>
>
>
>
>
>
>
>
>
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/005901cbff95$f1d020b0$d5706210$@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.
>From "Making Sense of Sedna & Visual FoxPro 9 SP2
>> There's all kind of reporting "goodness" in this book.<<
Understatement of the week for sure! The reporting goodness alone is worth the purchase price times three. No serious
VFP developer should be without a copy.
I am not just a paid spokesman, I am an author too.
Rick
White Light Computing, Inc.
www.whitelightcomputing.com
www.swfox.net
www.rickschummer.com
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/00d701cbff99$da794190$8f6bc4b0$@whitelightcomputing.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.
Author: MB Software Solutions, LLC
Posted: 2011-04-20 16:40:51 Link
On 4/20/2011 4:02 PM, Cathy Pountney wrote:
> *------------------------------------------------
>> From "Making Sense of Sedna& Visual FoxPro 9 SP2
> *------------------------------------------------
>
> Using the fxResetPageTotal class
>
> The way this feature works is a little odd, but it looks for the existence
> of a public variable called _ResetPageTotal. If it finds this variable, it
> takes that to mean you want it to track page counts and totals, which also
> means a two-pass run of the report is required. During the processing of the
> report, the first pass gathers the total number of pages for each data
> group. During the second pass, the _ResetPageTotal variable is updated at
> the beginning of each data group with the appropriate page count previously
> gathered for the data group. This means you can use the _ResetPageTotal
> variable on your report to get the total number of pages in a data group. In
> other words, if you want to print Page X of Y relative to the data group,
> use the following expression in your report.
> "Page " + TRANSFORM(_PageNo) + ' of ' + TRANSFORM(_ResetPageTotal)
>
> There's all kind of reporting "goodness" in this book.
>
> /SET SHAMELESS PLUG OFF/
>
> Cathy Pountney
Cathy,
Only things of "goodness" have come from your tips for years!!! We are
blessed to have you here. Thanks.
I'll even post the URL for the book since you didn't:
http://www.hentzenwerke.com/catalog/makingsos.htm
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/4DAF44D3.9050408@mbsoftwaresolutions.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.
Thanks Mike!! Always nice to hear my work is appreciated.
Cathy Pountney
> Cathy,
>
> Only things of "goodness" have come from your tips for years!!! We are
> blessed to have you here. Thanks.
>
> I'll even post the URL for the book since you didn't:
> http://www.hentzenwerke.com/catalog/makingsos.htm
>
> > --
> Mike Babcock, MCP
> MB Software Solutions, LLC
> President, Chief Software Architect
> http://mbsoftwaresolutions.com
> http://twitter.com/mbabcock16
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/006001cbffa5$44f9a810$ceecf830$@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.