I am using Crystal Reports to print invoices for our Warehouse in Australia. I am doing the development in the US.
The problem is:
The Crystal formated invoices take up too much bandwidth between the office in Kew, where the server lives and the warehouse in Campbellfield, where the printer lives. Taking 10+ seconds to print each invoice. Very painful when you have 100s and 1000s of invoices to print.
The solution was:
Convert the Invoices to PDF format using this simple piece of code:
With m_crwReport.ExportOptions
.FormatType = crEFTPortableDocFormat
.DiskFileName = strFullPath
.DestinationType = crEDTDiskFile
End With
m_crwReport.Export False
The new problem is:
I had the invoices formated for A4 paper (the standard metric size) and when it was converted for PDF the format was change to American Letter Size. Which shorted the form, so it no longer fit on the preprinted form. It also sacrificed the Barcode, making it 1/8 of its original size and unscannable.
The Question is:
Is there a way of telling the PDF form that it should use the A4 format?
Or is there a way of taking up less bandwidth, without sacrificing the integrity of the form?
The problem is:
The Crystal formated invoices take up too much bandwidth between the office in Kew, where the server lives and the warehouse in Campbellfield, where the printer lives. Taking 10+ seconds to print each invoice. Very painful when you have 100s and 1000s of invoices to print.
The solution was:
Convert the Invoices to PDF format using this simple piece of code:
With m_crwReport.ExportOptions
.FormatType = crEFTPortableDocFormat
.DiskFileName = strFullPath
.DestinationType = crEDTDiskFile
End With
m_crwReport.Export False
The new problem is:
I had the invoices formated for A4 paper (the standard metric size) and when it was converted for PDF the format was change to American Letter Size. Which shorted the form, so it no longer fit on the preprinted form. It also sacrificed the Barcode, making it 1/8 of its original size and unscannable.
The Question is:
Is there a way of telling the PDF form that it should use the A4 format?
Or is there a way of taking up less bandwidth, without sacrificing the integrity of the form?