total page number

[The Big Bear]

Hi All

I am trying to get a field to calculate the total number of pages that will be printed.

Example

page 1 of 6

I got the first field (1)to change as the page chnages but I can not figure out how to get the next field (6) to tell how many pages that are to be printed.

Thanks

Lionel

[Lee Smith]

This Topic comes up from time to time. I did a Search for [color:blue]+number +pages (include the Pluses) and it returned a lot of hits. Here is a recent one Link that will get you started.

Lee

[The Big Bear]

thanks lee

[SteveS]

Lee,

I tried some examples from other suggested links and come with the total number of pages of all records in my report instead of showing the total number of pages included within the one report I want to print. Some of my reports extend to 4 pages, others extend past 7 pages. It depends on the length of each report.

Example, I want my footer to show (Page 1 of 5), when printed.

I tried adding a global "gNumberPages" field in my report script

Enter Preview Mode

Go to Record/Request/Page [Last]

Set Field [gNumberPages ; get(PageNumber)]

Print

If you could solve this problem it would make things much easier for me.

Thank You,

Steve

[Lee Smith]

Hi Steve,

In the Search I provided, there were a number of examples. I noticed that a lot of the examples had the [color:blue]Find All Records step in them, but did not provide for a search. This is an extra step that isn't needed if you have already done a find to get your [color:blue]Found Set. One of the example files that you should look at is the one that [color:orange]bcooney Pointed to here, or go directly to the file Database Pros Site

HTH

Lee

Edited December 2, 2007 by Guest

[The Big Bear]

Lee

Thanks

I did used that DataBase Pro example and it worked perfectly

Thanks again for the help

Lionel

Edited December 2, 2007 by Guest

[SteveS]

Lee,

Thank you for your help, it worked!

The find request was key,

I was unsure of how to format the find request that you described so I performed a find on the serial number of my report and proceeded as directed.

How do I include a find request in this script: (find current record), that gives me my found set?

Steve