Crystal Reports 8.5 Page Footer data does not print in the right location

printmedia
printmedia used Ask the Experts™
on
Hi all.

We have a Crystal Reports 8.5 form that prints from our ERP software onto our preprinted invoice paper. We switched printers and now the report doesn't print the data in the right location on our preprinted invoice paper.

I fixed it so when the invoice is only 1 page long it prints in the correct location, but when the invoice is longer (i.e. 2 invoices need to be printed) then the data appears in the right location on the last page but the data is moved down on the first page.

For example, if an invoice has 20 lines then that means 2 invoices print, on the second page the data in the 2 page footers (page footer a and page footer b) appears in the right location on the preprinted invoice paper, but on page first page the data in both page footers appears lower than where it should be.

If the invoice is only 2 lines then that means 1 invoice prints, in this example everything appears in the right location.

Any idea on how I can get this report to print in the right locations on the preprinted invoice paper regardless of how many pages are printed?

Thank you in advance!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010

Commented:
First step is to edit it in Crystal 8.5, set it to your new printer, and resave it.

FWIW, which ERP software?

Author

Commented:
MAS200
Top Expert 2010

Commented:
OK, just checking, I'm an Accpac ERP guy, it has another trick to fix printing problems like this.  

Try my first suggestion, it may be that the report is set to "No printer", or simply a generic printer like HP 4.

Author

Commented:
Ok I think I figured out what is happening.

I have my two page footers A and B.

If the invoice is one page, then page footer A will contain some data and page footer B will contain some data.

If the invoice is more than one page long, then page footer A will not contain data in the first page but page footer B will have data. And on the second invoice printed both page footer A and B will contain data.

What is happening is that if page footer A does not contain data then the data on page footer B moves up a little, how can I get the crystal report to keep the same height of page footer A even if there is no data?
Top Expert 2010

Commented:
Right-click on Page Footer A, go to Format Section, and uncheck the Suppress Blank Section box.

Author

Commented:
That section is already unchecked
Top Expert 2010

Commented:
I knew you were going to say that...

Any conditional formatting formulas?

Author

Commented:
2 of the fields in page footer A have a "Suppress" formula
Top Expert 2010

Commented:
How about the Page Footer itself, i.e., the Suppress (No Drill-down) button?

Author

Commented:
Here is the formula:

{myField}<>"Y"

The suppress checkbox is NOT filled in.

Author

Commented:
Yes, the page footer has the following formula:


{myTable.InvoiceNumber}=Next({myTable.InvoiceNumber})and {myTable.HeaderSeqNumber}=Next({myTable.HeaderSeqNumber})

Open in new window

Top Expert 2010

Commented:
Ding, ding, ding!  

Comment it out and see what happens.

Author

Commented:
You're right that fixed it. But we still don't want the data in page footer A to appear on the first page (unless there is only one page), but only on the last page.

Author

Commented:
You're right that fixed it. But we still don't want the data in page footer A to appear on the first page (unless there is only one page), but only on the last page.
Top Expert 2010
Commented:
Ah, then take the footer suppression formula and put it in all the fields.

Author

Commented:
Thanks for all your help and patience.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial