Setting the Paper Size to A4 for a Crystal Report

Posted on 2006-03-22
Medium Priority
Last Modified: 2012-06-27
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?

Question by:purplesoup
  • 4
  • 2
LVL 101

Expert Comment

ID: 16265466
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).



Author Comment

ID: 16267742
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?
LVL 101

Expert Comment

ID: 16272724
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.

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.


Author Comment

ID: 16380100
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?
LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 16388230
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.

LVL 101

Expert Comment

ID: 16397111
Glad i could help


Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month16 days, 1 hour left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question