[RESOLVED] Crystal Report Paper Size Problem

I use Crystal Report 8.5 (Crviewer1)

I have a report that is too wide. It's about 8.50in x 38.50in in landscape mode. I designed the report using the Microsoft XPS document Writer as default printer. I used the above as my default printer so that I can create my custom paper size via the Print Server Properties.

My dilema: :confused:

The only printer that we use here in the office is a laserjet HP 1020. Every time I fire up my VB to print the above report, the settings are messed up. Is there a way in crystal that my setting will not be messed up? I mean if the report is too wide, I need crystal to print the excess to another page. I hope you get what I mean. This is driving me nuts.

Pls. Help. My last resort to this problem is buy a big printer. What a bummer!

Make a duplicate of your rpt
name it accordingly
Redesign it in Crystal Reports but now using the hp printer as default
Probably you'll need to reduce font size or develop 2 rpt if it is too wide

yep that's what I did. I reduced the font size to 6 just to fit the fields on a 8.5 x 13 paper. It sucks! LOL.

I just wish crystal was dynamic at handling paper sizes. Let the printer do the rest. Just like printing excel spreadsheets where it does not matter how many columns you have, and the printer will just print the pages accordingly.

Sigh...I decided to order a new wide printer. Bummer!