Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

lf_fk_bkk
New Contributor III

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

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.

good_bad.png

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.

1 Solution

Accepted Solutions
lf_fk_bkk
New Contributor III

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

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

5 Replies
lf_fk_bkk
New Contributor III

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

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?

lf_fk_bkk
New Contributor III

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

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.

lf_fk_bkk
New Contributor III

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

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

lf_fk_bkk
New Contributor III

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

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

lf_fk_bkk
New Contributor III

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

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!

Community Browser