Page Numbering Out of Sequence 1

[melsch]

Crystal XI

We have a estimate report that when we print it, the page numbering is not in sequence. On an estimate that is 3 pages, for example, the first page could be numbered 1 of 1, the second page may also say 1 of 1, the third page may then list 2 of 3, etc. I have looked at the page footer (PFa) for the page numbering and this is set up as a formula

("sPage")+" "+ToText(PageNumber,0)+" "+("sOf")+" "+ToText(ToTalPageCount,0)

Even if I change this to be one of the special fields and insert Page N of M, the same thing happens.

Note, this is happening with the Report Header (RH) set to Hide. The RH also has the box checked, "Reset Page Numbers After" and the formula of:

Not IsNUll({?@DisplayHeader}) And {?@DisplayHeader}<>0

I'm assuming if this section is set to Hide, this option is ignored. When I un-hide the report header, the page number is correct. We do not want the Report Header to print because these estimates are sent to the customer and they should not see the report parameters that were chosen to run the report.

The Page Header (PFa) does not have suppress checked or any other formulas associated with it.

How do I get the page numbers to print correctly without making the report header visible?

This was originally a canned report that was modified but I don't believe the changes were related to the page numbering.

Appreciate any help.

 

[lbass]

Since you are not showing the report header, why not remove the reset page number after checkmark and formula?

-LB

 

[melsch]

Thanks, lbass.

I tried as you suggested. The report is now showing the first page as 1 of 1, and consecutive pages as 1 of 4, 2 of 4, 3 of 4, and 4 of 4.

 

[melsch]

lbass:

Realized I forgot to remove the formula from under the Reset Page Numbers After. Once I removed this formula, the page numbers are showing correctly.

So, just for my clarification, even though a section is hidden, it still processes any formulas that may exist under other options chosen in that section?

I'm just learning Crystal so this is a new lesson for me.

Thanks for your help!

 

[lbass]

Suppressing or hiding is just changing the display, so yes in general that is true--but one exception is that if you hide or suppress a subreport, it will not execute.

-LB