Page n of m is wrong

[cakoliver]

I have a report where page n of m is always wrong. To be more accurate, m is always wrong and always two pages too low.
If the report has 12 pages, this will read Page 1 of 10, 2 of 10 etc all the way to 11 of 10 and 12 of 10.
Has anybody seen this before? Any ideas on where to start looking?

Thanks,
Jeff

 

[Ngolem]

sometimes when a page footer splits across 2 pages, crystal has trouble with the math on page count...

 

[cakoliver]

Ngolem,
I don't believe that's the issue here,the only page footer is one line tall and shouldn't be split across 2 pages. Any other ideas?

Jeff

 

[kenhamady]

What version of CR are you using?
Are you within an app or standalone CR?
Does this happen in preview or only on paper?
Is this in any other reports, or just this one?
Does it happen if you save data with the report, close and reopen? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[cakoliver]

Ken,
1. Using CR8 Developer Edition.
2. Standalone CR
3. Happens in both preview and print
4. So far, I've only seen it in this one report
5. Yes, I saved the data with, then reopened and the problem still occured.

Thanks,
Jeff

 

[kenhamady]

What happens if you select a different printer in printer setup?
Do you have any conditionally suppressed sections?
What if you try it on another PC? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[Ngolem]

when does the page count fail....from the start...in the middle?? Can you tie it to something being printed.? Is it random or consistent??

Jim

 

[cakoliver]

Ken / Ngolem,
The problem occurs regardless of printer.
There are conditionally suppressed sections.
The problem occurs on other pc's.
I'm beginning to think that it is related to conditional suppression, that two pages worth of information may be printing that perhaps should not.
Is it possible that Crystal, in it's first pass to determine total page count, is evaluating the conditional print differently than it does at print time?

Thanks,
Jeff

 

[kenhamady]

What are the conditions used?
On what sections?
Are there variables involved?

Usually these factors should all be taken into account,but you might have a unique combination that throws it off. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[cakoliver]

Ken,

The conditions used are pretty complicated, there are formulas involved and one value used in the conditions comes from a subreport. The client requesting this report has a pretty convoluted set of criteria that determine whether a particular job is included or not.
Do you need to see the details or is the above info enough?
The conditions in question are used on GH2 thru GF2 and the details section as well as subreports in those sections.
As stated above, there are variables involved.

Thanks,
Jeff

 

[kenhamady]

Wow. I could see any of those potentially causing a problem, depending on how they interact with each other. I have never seen this problem so off the top of my head, I am not sure which one it is.

To be more specific I would need the details, but your description sounds too complex to tackle here in TT. If you need more help you might need to hire someone to dig into the report. Several of the experts here have signatures that indicate they can be 'rented', but those discussions should be outside of TT. You might be able from here to track it down on your own.

Good luck. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[cakoliver]

Ken,
Thanks for your help. The questions you have asked sort of got me started, hopefully in the right direction.
I'm going to dig around for a while before I consider passing the problem along to someone else. I'll let you know if I can determine the cause.

Thanks,
Jeff