*------------------------------------------------ >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: [email protected] [mailto:[email protected]] On > Behalf Of Tina Currie > Sent: Tuesday, April 19, 2011 9:32 AM > To: [email protected] > 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: [email protected] 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.
