Page x of y
Jeff Harrison
jeffaharrison at yahoo.com
Wed Oct 12 19:37:22 PDT 2005
--- "Brian K. White" <brian at aljex.com> wrote:
>
> ----- Original Message -----
> From: "Gary Olman" <garyolman1 at hvc.rr.com>
> To: "'Filepro-List'" <filepro-list at seaslug.org>
> Sent: Wednesday, October 12, 2005 9:14 PM
> Subject: Page x of y
>
>
> > The most annoying problem I have is getting "page
> x of y pages" working on
> > a
> > filepro report . Filepro 5.0.14 windows XP. Every
> thought I have works
> > 90%.
> > Does some one have a way of making this work 100%
> of the time? Thanks
> > Gary
>
> Only possible way can be post-processing.
> You don't know the total until you are all done.
...[snip]
Well, on a report you do know how many records you are
going to print before the request output processing
starts. So if you fix the number of records per page
to a given number, then it should be possible to
calculate how many pages you are going to print.
So for example if you specified 50 as the "Number of
forms down page" then the number of pages that you
will print is @ts/"50". If there is a remainder then
add 1 more page.
Ex:
FormCount = "50"
TotalPages = @ts/FormCount
If: (@ts/FormCount) ne int(@ts/FormCount)
Then TotalPages=TotalPages+"1"
Of course it is not always possible to fix the number
of records per page - you may be doing fancy things
such as print statements and the like. However, for
plain vanilla reports this should work I would think.
Jeff Harrison
jeffaharrison at yahoo.com
Author of JHExport and JHImport. The easiest and
fastest ways to generate code for filePro exports and imports.
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
More information about the Filepro-list
mailing list