topic Re: Sheet printing in QlikView

Sheet printing

Anonymous — Fri, 07 Sep 2012 18:13:10 GMT

I want to print the sheet using macro but I dont get the backgroud printed in the output.

Anyone who knows the command for enabling background printing.

Also let me know if there is any command for page size in print options.

Anonymous — Fri, 07 Sep 2012 20:04:06 GMT

See SheetPrintDrawBackground in API Guide:

set docprop = ActiveDocument.GetProperties

set ps = docprop.PrintSheetSettings

ps.SheetPrintDrawBackGround = true

ActiveDocument.SetProperties docprop

Anonymous — Sat, 08 Sep 2012 05:12:52 GMT

Not quite working

Below is what my report looks like:-

This is what i get by printing using macro:-

sub export

set docprop = ActiveDocument.GetProperties

set ps = docprop.PrintSheetSettings

ps.SheetPrintDrawBackGround = true

ActiveDocument.SetProperties docprop

ActiveDocument.sheets("Main").print

end sub

Anonymous — Sat, 08 Sep 2012 05:20:03 GMT

The report in viewer

the print document

Anonymous — Sun, 09 Sep 2012 13:59:39 GMT

How it works if you print sheet manually, without macro, and check "draw background"?

If they work differently, it is a bug in API. If they work the same way, you probably miss something.

Regards,

Michael.