Datareport printing problem

I have set up a printer with a custom page 11 x 5.5 inches and default layout to portrait in the printer control panel. When I run the report, it has no problem when viewing it. It is right exactly i want. 11x5.5 and portrait.
But when I click the button print, the print layout in dialog box always default to landscape, so I have to choose manually to portrait before print it to printer.
My question is how to set the default to portrait when clicking the button print? It has no problem when using the standard size such as letter. It's only problem when using a custom page.

Any comments and help would be appreciated.
LVL 1
falconewAsked:
Who is Participating?
 
SpideyModCommented:
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0
 
MikkilCommented:
Falconew,

Use the printer object to confirm what you have done in the panel.

Mikkil
0
 
Anthony PerkinsCommented:
There should be no need to change the printer properties in the Control Panel.  The Data Report (at least if you have isntalled SP4 or SP5) has properties to set this:
ReportWidth
Orientation
LeftMargin & RightMargin
BottomMargin & TopMargin

Anthony
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
falconewAuthor Commented:
When I set it to portrait using orientation property, an error message occur "Report width larger than paper". I have verified that my report is not larger than paper. I set the left and right margin to 0. and report width=10470.
When I change the paper height in the printer property to about 8 inch, the error didn't occur.
Even I change the paper width to 16inch, the error still occurs.
It is strange, why do I change the height the error didn't occur?
When I comment the orientation, the report shows correctly. But the problem is only when I click the button print on the report window, in the dialog box always default to landscape.

Any comments and help would be appreciated
0
 
Anthony PerkinsCommented:
Again, are you using at least VB6 SP4?  If so, take a look at the following articles from MSDN:
FIX: Error Message "Report Width Is Larger Than the Paper Width" When Showing Data Report in Landscape (Q261193)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q261193&SD=MSKB&
FIX: Error Message "Report Width Is Larger Than the Paper Width" on Exporting Data Report (Q253555)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q253555&SD=MSKB&
PRB: Report Width is Larger than the Paper Width (Q197915)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q197915&SD=MSKB&

Anthony
0
 
falconewAuthor Commented:
I have installed VB6 SP5.. It is the same behaviour when I move to another OS.
I have also search the MSDN before posting this question here. From direction of MSDN I set the left and right margin to 0, and report width 10470 twips and 1440 twips equal 1 inch. So my report width is 10470/1440 = 7,2 inches.
In the printer property I set up a custom paper size 8.5 inches wide and 5.5 inches length and I set it as the default paper size for my printer. I also set it to portrait as the default.
The report show correctly in the preview windows of datareport which the length is 5.5 inch and the width is 8.5 and it is portrait. But when I click the button print on the preview report, it always default to landscape in the print dialog box. So I have to choose the portrait manually before printing the report.
When I set the orientation to portrait, the error occur 'The report larger than paper'. This doesn't happen when I use standard format such as letter, or I change the length of the custom size greater number such as 10 inches.

What's the problem..

Regards
0
 
Anthony PerkinsCommented:
I am out of ideas.

Sorry I could not help any more,
Anthony
0
 
DanRollinsCommented:
falconew, an EE Moderator will handle this for you.
Moderator, my recommended disposition is:

    Refund points and save as a 0-pt PAQ.

DanRollins -- EE database cleanup volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.