Data Report Designer - rotation

[wvjim]

Does anyone know how to rotate the report from portrait to landscape in the report designer. I've looked through all the properties and can't find anything that'll allow me to do that and expand the report to fit onlegal paper in landscape mode. I can accomplish that with either Microsoft Word or Access but won't have either of those products available in all of my client sites.

Thanks in Advance

 

[MangroBongacello]

Download Service Pack 5 for VB then you can set at run time (before you show or print the report) MyReport.Orientation = rptOrientLandscape

Mangro

 

[bboggessswcg]

The orientation works, but how do you tell it to change the paper type to legal?

 

[petevick]

You have to set the default printer paper size via the Printing Preferences dialog before showing your report. I add a button that shows the printer folder, the command is

Shell ("rundll32.exe shell32.dll,SHHelpShortcuts_RunDLL PrintersFolder&quot

this gives quicker access to the printers. Bit of a pain, but I know of no other method in code.