DataReport Master...Help.

[shaileshadate]

Hi I tried this code to change my DataReport Paper Orientation..

Printer.PaperSize = vbPRPSLegal '10x14
Printer.Orientation = vbPRORLandscape 'Landscape

But it doesn't work.. Everytime I show the DataReport, it doesn't change..

I try to use even Common Dialog box but it doesn't work.. Any idea even an API code?

Kindly help me what code should I do?

[Bombdrop]

This only works with Service pack 4 and onwards ( definatley aone of the latter service pack) download the lattest service pack from microsoft thats service pack 6

[shaileshadate]

I already have Service pack 5 installed on machine and it is not solving my problem.

[Bombdrop]

It's not the Printer object you need to look at but the report object itself.

Option Explicit
Public Con As New Connection
 Public Rec As Recordset
Private Sub Command1_Click()
 
Set Rec = New Recordset
Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Visual Studio\VB98\BIBLIO.MDB;Persist Security Info=False"
Rec.Open "select * from Authors", Con
With DataReport1
Set .DataSource = Rec
    .Orientation = rptOrientLandscape 'Set the report orientation not the printer
    .Show
    .PrintReport
End With
 
End Sub

Hope this helps