Changing Printer Orientation through Code

[pkelly]

Hopefully I have the correct forum for this question...

I have a button pointing to the following script…

sub ReportPrint

ActiveDocument.ActiveSheet.Print()

end sub

This is working great.

I am working on a new report and want to print tab 1 portrait with tab 2 being printed in landscape mode.

I know how to change the orientation through the print set up but this applies to every tab.

What I would like to is have to different sub routines…

One which forces the printout to landscape and one which forces the printout to portrait…

So would have something like….

sub ReportPrintLandscape

Force Print Settings to Landscape

ActiveDocument.ActiveSheet.Print()

end sub

sub ReportPrintPortrait

Force Print Settings to Portrait

ActiveDocument.ActiveSheet.Print()

end sub

I am struggling with the command line for changing the print orientation…

Any help greatly appreciated...

[Oleg_Troyansky]

I'm not sure how you can do it using VBScript functions - perhaps there is something (outside of QlikView).

As an alternative solution - you can define a QlikView Reports (using "Reports" menu option) and in the report you can declare one page as Landscape and another page as Portrait. Then, instead of Printing Sheet, you can print a Report.

good luck!

Oleg

[pkelly]

Thanks Oleg...

I am new to QlikView and have no experience of the "Reports" menu option.

I have searched for support documentation (manual) for this with no success...

Do you know of any support documentation that would help?

[Oleg_Troyansky]

There is a brief description of Reports Menu in Chapter 17 of the Reference Manual (should be installed under \QlikVIew\Documentation as part of the Complete installation)

Oleg

[pkelly · Accepted solution]

Thanks Oleg

Have come up with a workaround...

I am opening the print dialog box and the user can select the orientation they want...

ActiveDocument.ActiveSheet.DialogPrint