Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Print Macro Issue

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? 

2 Replies
Not applicable
Author

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

kji
Employee
Employee

Print has an optional parameter for print background, try:

ActiveDocument.ActiveSheet.Print true