Pagenumbers

Hi,

Does anyone know how to number pages accross a document, e.g.
Report1 page 1 of 28
page 2 of 28
Report2 page3 of 28
page 4 of 28
Report3 …etc

Report5 page 28 of 28

Cheers,

Johan de Waardt
ABN AMRO Bank


Listserv Archives (BOB member since 2002-06-25)

Hi Johan:

Try – =DocumentName() & ": " & FormatNumber(Page(), “0”) & " of " & FormatNumber(NumberOfPages() ,“0”)

Robert

Schmidt Interactive Software, Inc.

Does anyone know how to number pages accross a document, e.g.
Report1 page 1 of 28
page 2 of 28
Report2 page3 of 28
page 4 of 28


Listserv Archives (BOB member since 2002-06-25)

The only way we found to do it was to create a DLL with our own function that keeps track of page numbers.


Listserv Archives (BOB member since 2002-06-25)

Hi Johan. This was posted previously by Dave Rathbun. I’ve found it to be very handy. I do not know of a way to continue page numbers across multiple reports within the same document which I think is what you are after. But… this formula will give you a display of (for illustration) “Page 1 of 20” in report 1 of document 1 and “Page 1 of 15” on report 2 of document 1. The number of pages is report dependent.

One alternative is to use the + concatenation operator instead of the &. The & requires character strings only, the + seems to work with any data type. The following formula gives the same result as the previous:
= "Page " + Page() + " of " + NumberOfPages()

Best regards,

Crystal Golding
Senior Systems Analyst
Management Information Section
University of Queensland
Brisbane Australia 4072
E-mail: c.golding@mailbox.uq.edu.au
Phone: +61 7 336 57289
Fax: +61 7 336 58202


Listserv Archives (BOB member since 2002-06-25)