Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Data Report

A friend of mine is using Data Report to generate reports in his application, but he wanted them to be displayed and printed as landscape reports, instead of portrait. Is there any way in which he can do this??

He asked me if I knew, but I don't know either.

Comments

  • jlegjleg Member Posts: 237
    : A friend of mine is using Data Report to generate reports in his application, but he wanted them to be displayed and printed as landscape reports, instead of portrait. Is there any way in which he can do this??
    :
    : He asked me if I knew, but I don't know either.
    :

    You have to set the printer object to Landscape this is done before calling your report the syntax is;


    Printer.Orientation = vbPRORLandscape

    You can also set the orientation of you report, syntax is;

    rptMyReport.Orientation = rptOrientLandscape

    Remember if you are trying to print to a printer other than the default you need to SET the required printer first before changing any of its properties.

    Hope this helps

    John ;-)

Sign In or Register to comment.