Author: Cathy Pountney
Posted: 2011-04-20 at 16:02:57
*------------------------------------------------
>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.