Datareport is causing me a heart attack!

[bomayed]

I have a paper size of Height: 5.50 Width:8.50 INCH

I'm using Epsson Printers and OS Windows XP.

I created a special document size and assigned it to the Epsson printer.

now each 1440 = 1 inch right? ok

So I set my reprot width to 7920 and height 12240


now , when I try to print the report , the printer changes the paper orientation from Portait to Landscape !

did I tell the printer to do so ? NO , it just changes it automatically!

So what wrong am I doing here !!!? why is it changing to landscape


and the funny thing , when I increase the height size of the form I have created in the printer settings , the reports appears in portait mode!!

I don't understand , please help me out

[bomayed]

Any ideas?

[brucevde]

I have a paper size of Height: 5.50 Width:8.50 INCH
...
So I set my report width to 7920 and height 12240

The above statements contradict each other.

Height = 5.5 * 1440 = 7920 but you set it to 12240
Width = 8.5 * 1440 = 12240 but you set it to 7920

[dee-u]

When are you changing the report's width? Design-time or run-time? You may need to change the PaperSize at run-time...

[guyjasper]

you may want to set printer orientation (http://support.microsoft.com/default.aspx?scid=KB;en-us;q198901) through code. take a look at the link.

[Bombdrop]

You can change the Orientation by uising the code below it requires you to have service pack 4 or above ( Vb last service pack was 6 and i sugest you download it).


Option Explicit

Private Sub Command1_Click()
DataReport1.Orientation = rptOrientLandscape
DataReport1.Show
End Sub


Hope this helped!!
:wave: :thumb: :wave:

[Hack]

Moved to Reporting section