printmedia
asked on
Crystal Reports 8.5 Page Footer data does not print in the right location
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!
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!
ASKER
MAS200
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.
Try my first suggestion, it may be that the report is set to "No printer", or simply a generic printer like HP 4.
ASKER
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?
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?
Right-click on Page Footer A, go to Format Section, and uncheck the Suppress Blank Section box.
ASKER
That section is already unchecked
I knew you were going to say that...
Any conditional formatting formulas?
Any conditional formatting formulas?
ASKER
2 of the fields in page footer A have a "Suppress" formula
How about the Page Footer itself, i.e., the Suppress (No Drill-down) button?
ASKER
Here is the formula:
{myField}<>"Y"
The suppress checkbox is NOT filled in.
{myField}<>"Y"
The suppress checkbox is NOT filled in.
ASKER
Yes, the page footer has the following formula:
{myTable.InvoiceNumber}=Next({myTable.InvoiceNumber})and {myTable.HeaderSeqNumber}=Next({myTable.HeaderSeqNumber})
Ding, ding, ding!
Comment it out and see what happens.
Comment it out and see what happens.
ASKER
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.
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for all your help and patience.
FWIW, which ERP software?