topic Print Macro Issue in QlikView

Print Macro Issue

Anonymous — Wed, 20 Jul 2011 16:14:52 GMT

I have a button that prints a sheet while hiding several items that don't need to be printed. It works fine. However, the sheet has a background image that will not print when using this button. If I right click within the sheet and select print, the background image prints fine but it also prints everything I don't want printed.

The background image won't print even if I delete all the code out of the macro except

ActiveDocument.ActiveSheet.Print

Any Ideas? Is there another way to print the sheet via a macro?

Print Macro Issue

Thu, 15 Sep 2011 13:23:33 GMT

Hi,

We have the Inbuilt Macro in the Qlikview in the Action Tab.

Create a Button and go the Actions add aPrint Sheet action,give the sheetid and then enable the Print with Background Option.its available in QV 10.Let you check once if ur using othar than this version.

Regards,

Santhosh Kumar G

Print Macro Issue

kji — Thu, 15 Sep 2011 13:31:40 GMT

Print has an optional parameter for print background, try:

ActiveDocument.ActiveSheet.Print true