Total Number of pages in report

[Spiral]

Hello all,

I created a columnar list report layout.

Now, what I want to show the user is the total number of pages.

In the footer, I have a page number symbol with the word "Page" in it.

When I click preview mode, it reads Page 1. The report is actually 3 pages long. I want it to say:

Page 1 of 3.

How can I get it to show me the total number of pages in this report?

[bcooney]

Try JMO's technique: Page # of #

[Spiral]

Hi bcooney,

Thank you very much. ;)

[Spiral]

bcooney,

I setup my db to match JMO's technique and for some reason it is not working.

I inserted the "Records found" field in my report to verify that it has a value and it correctly shows the number of records, but the "Total pages" field is not showing any value. Any ideas?

[Lee Smith]

There is a script that has to be imported to make this work.

It basically goes to the last page, and then returns to the first page. This populates the Total pages to be printed. It also takes you into the Preview Mode where the pages will then show.

HTH

Lee

[bcooney]

As Lee says, check the report script for the setting of the global Total Pages field.

[Spiral]

Sorry, forgot to mention that I also matched the report script and it still isn't working for me. ;)

[Spiral]

Ok. It's working.

I had the pause option checked for enter preview mode in the script. Big thank you for your help. :;)