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)