Re: Page Numbers - Data Grouping in Reports

Author: MB Software Solutions, LLC

Posted: 2011-04-20 at 16:40:51

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

http://fabmate.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/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.

©2011 MB Software Solutions, LLC