topic Re: Gauge in straight table disappears when batch print PDF job run by logged off user in QlikView

Gauge in straight table disappears when batch print PDF job run by logged off user

Anonymous — Fri, 16 Dec 2011 12:56:15 GMT

Hello there!

I am generating PDF files in batch mode using macros, specifically printing a particular sheet with the command ActiveDocument.ActiveSheet.Print and PDF X-Change 3.0 as the driver. The batch job itself calls Qv.exe (10SR3), and uses the OnOpen trigger.

Now, the funny thing is that if I run this task when I am logged on, everything works fine. If I am logged off it still runs and the PDF gets created, but all the mini gauge butterfly charts in my straight tables disappear, with only the background showing.

Has anyone here had the same problem? (You might say "use another printer driver", but which one? Not necessarily Bullzip, that one gives the error message "...PrinterName property must be set before .." )

Or, is this corrected in SR4 with one of these two fixes?

43036

Developer - Gauge Chart expression not always calculated

33553

Printing a Gauge Chart in a report doesn't work, only part of the object shows

My software is: QV 10SR3, running on Windows 2008 R2, with PDF-XChange 3.0.

Gauge in straight table disappears when batch print PDF job run by logged off user

Anonymous — Fri, 16 Dec 2011 15:02:28 GMT

Well, tabulate my trousers... the same behaviour occurs in our test environment which runs QV 11 --- so I guess it must be related to the printer, then(?)

Does anyone know of a good, free printer driver which requires no user interaction when printing?

Gauge in straight table disappears when batch print PDF job run by logged off user

Anonymous — Fri, 16 Dec 2011 15:18:57 GMT

A little supplementary testing seems to indeed place the blame on the printer driver --- when calling ExportBitmapToFile as well as printing the sheet, the gauges show up in the generated image whether the user is logged in or not.

Re: Gauge in straight table disappears when batch print PDF job run by logged off user

Anonymous — Wed, 21 Dec 2011 12:30:24 GMT

A little update:

I have now tested this with Bullzip as well as several postcript printers, all of which give the same result --- the gauges fail to print as they should.

It turns out I was wrong, and seemingly the actual culprit is either QlikView, or some windows phenomenon which affects printing in general.

Argh

Gauge in straight table disappears when batch print PDF job run by logged off user

Anonymous — Tue, 07 Feb 2012 15:31:14 GMT

Hi,

you need to add a WaitForIdle and or Sleep statement to your script before calling print on line 18. I'm guessing that since your report is fairly complex the gauges simply don't have time to render before you print.

(This might not explain why ExportBitmapToFile does work, but at least it solves the problem... )

Re: Gauge in straight table disappears when batch print PDF job run by logged off user

Anonymous — Tue, 07 Feb 2012 15:32:39 GMT

lf_fk_bkk wrote:
Hi,
you need to add a WaitForIdle and or Sleep statement to your script before calling print on line 18. I'm guessing that since your report is fairly complex the gauges simply don't have time to render before you print.
(This might not explain why ExportBitmapToFile does work, but at least it solves the problem... )

Thanks dude, that worked!