I am using Crystal Reports v8.5. I am having the problem with printing the report onto the A4 size paper. The RPT file was designed with the paper size 8.5 x 11 inches in mind. The Crystal Reports v8.5 CRE engine would print fine with 8.5x11 paper but would not scale correctly on the A4 paper, chopping parts of the report on the right handside.
Does anyone experience the same problem? If so, how do you fix it programmatically or with the Crystal Report Designer?
Your problem is not unique to the 8.5 version (I have worked with every version from 4.0 through 12.0 called CR 2008).
Unless you manually set up margins in Crystal, the program will look at the settings of your default printer, specifically for the unprintable area on each side where the printer cannot reach … and use those measurements.
When you changed to A4 which is 6 mm narrower and 18 mm longer than 8-1/2 X 11 inch paper, right-hand columns were shoved off the page either fully or partially.
You only have one option: open the report in the Crystal Report program, and manually adjust the columns.
The right-hand columns moving unexpectedly happens to reports where margins are NOT manually set, and then the report gets printed to a different default printer. I try to encourage report designers to ALWAYS set their margins on each report. It usually stops this column movement from happening in the future.
I may want to explore with PESetMargins(). Do you know what the measurement unit values for the margin parameters used by PESetMargins()? Besides changing the columns in the RPT files to fit A4, did you try programmatically change the margins at the run-time?
Setting the report margins dynamically at run-time does not help. Your original recommendation is the only solution for now. That is I had to modify the margin settings for the desired report (*.RPT) file(s) to accommodate for the A4 page-size document.
(BOB member since 2008-06-05)