Total # of Pages

[nancye]

I have a report with 127,681 pages, my text field that shows # of pages
shows 1 of -3391 How do I get the 127,681 to show?

 

[Marshall Barton]

I have a report with 127,681 pages, my text field that shows # of pages
shows 1 of -3391 How do I get the 127,681 to show?

According to Help - Specifications, reports can have up to
64K pages so I am surprised you can actually get that much
paper out a report or, for that matter, a printer.

That number being suspiciously like twice the max value in a
16 bit unsigned short integer, I suggest that if there is
any hope of getting the full number, try setting the text
box to the expression:
=IIf(Pages < 0, Pages + 2 ^ 17, Pages)

 

[nancye]

I am actually converting the report to pdf. I will try your suggestion.

 

[Gina Whipp]

Was answering this question but I see you haven't tried Marshall's solution
yet...

nancye,

Where (in what section) do you have the text field that prints the page
numbers? Page Footer? If yes, make sure in the Properties Window for the
report it shows 'All Pages'. If it's not there then let us know where you
have the placed it.

So IGNORE if Marshall's suggestion works!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[nancye]

I split the report in 1/2. THis report now has 63,840 pages.
Your suggestion did not work it gave me: 129376.

 

[Marshall Barton]

I split the report in 1/2. THis report now has 63,840 pages.

This is a very good idea. For the sake of your printer, it
might be worthwhile splitting it into even more chunks. I
can't imagine anyone reading all that or how they would find
a particular part even if it's all electronically
distributed.

Your suggestion did not work it gave me: 129376.

That's an odd result. I can't explain it unless the number
of pages somehow changed.