topic Changing Printer Orientation through Code in QlikView

Changing Printer Orientation through Code

pkelly — Thu, 23 Apr 2009 18:44:51 GMT

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...

Changing Printer Orientation through Code

Oleg_Troyansky — Thu, 23 Apr 2009 19:05:37 GMT

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

Changing Printer Orientation through Code

pkelly — Thu, 23 Apr 2009 19:14:48 GMT

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?

Changing Printer Orientation through Code

Oleg_Troyansky — Thu, 23 Apr 2009 19:21:49 GMT

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

Changing Printer Orientation through Code

pkelly — Thu, 23 Apr 2009 19:57:31 GMT

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