Setting the Paper Size to A4 for a Crystal Report

We have a supplier from the US who writes some Crystal Reports for us.

They insist they always set the printer page size in the reports to A4.

In our office (in the UK) the reports all print ok - we have an HP Color LaserJet 5500 PCL 6.

However in our other UK office the reports do not print ok: on their OKI printer it displays 'Paper Mismatch', their HP 4000-family printer it displays the message 'Load Letter' and then sit there until you press the green Go button a couple of times.

I have opened one of the reports up in Crystal Reports but the page size seems to vary depending on which printer I am pointing at. By default it opens on "Fax" and has page size "letter".

When I change the printer to "HP Color LaserJet 5500 PCL 6" it is still Letter.

When I change the printer to "HP LaserJet 4000 Series PCL6" it is still Letter

but when I change it back to "HP Color LaserJet 5500 PCL 6" it is now A4.

If I open Word and set the printer to "HP Color LaserJet 5500 PCL 6" the page size is A4.

All the trays for our HP printer are set to A4.

How can I tell what the Crystal Report printer page size is set to and can anyone explain what is happening?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Crystal uses the printer driver to provide the paper sizes that are available.  If you build the reports against one printer driver and it isn't available on the production machine then it tries to use the default printer

There are 2 solutions
1.  Have your developer provide you with reports that use the appropriate printer driver for your clients..
  ie.  They will provide one that is built and saved against the HP Color LaserJet 5500 PCL 6 for all users that have a HP Color LaserJet 5500 PCL 6 as the default printer.
     They will provide one that they change the printer on and save it to use the OKI printer same for the HP 4000.

2.  Use the same printer driver at all locations.

Look at this link for how Crystal is dependent on the printer driver. (It is for earlier version of Crystal but it is still applicable).

purplesoupProgrammerAuthor Commented:
This is a long document, but it appears to be saying that when writing a report you should not use page size A4 or letter but hard-code a specific page size for each report. Is that how you read it?
Not sure what you mean by hard-code it.

Generally, you should setup the printer as you create a report.  
Use the printer setup to select the printer and paper size.  
Make them the default
Then create the report.  The report will automatically set itself up to use the default printer and paper size.

OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

purplesoupProgrammerAuthor Commented:
Sorry I haven't got back to this recently.

Are you saying make the setting you want for the report the default settings for the printer at the time the report is created, then the report will use those settings (e.g. Page Size A4) for any other printer that prints the report?
I believe that is true so long as the same printer driver is used and it has A4 as an option.  If you change printers then all bets are off.  Crystal is very dependent on the printer driver.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Glad i could help

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.