Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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... )
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?
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.
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
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 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!