topic Qlikview PDF in 9 in QlikView

Qlikview PDF in 9

Fri, 11 Sep 2009 08:12:05 GMT

Hi, All

As i noticed that Qlikview 9.0 server installation includes 'PDF-Xchange 3', does it mean that we don't have to use Qlikview PDF for pdf printing in future?

Our current approach is to use macro to print pdf when the qv reloads the scripts.

If we are going to use 'PDF-Xchange 3', how are we going to do the automated pdf printing?

I am now confused whether i should continue to use the earlier Qlikview PDF way for automated report printing or i should switch to the new pdf tool?

Anybody has experienced this already?

Best Regards

Mingming

Qlikview PDF in 9

Thu, 10 Dec 2009 19:47:06 GMT

Hi !

You can try this. It works for me:

First, you have to set PDF-XChange print defaults for not to ask for a filename:

In "File" and "Pathname" you can write whatever you want.

This setting will make PDF-XChange print without prompting anything to the user.

Now the macro:

function PrintReport(sReport, sDestination)

ActiveDocument.PrintReport sReport, "PDF-XChange 3.0"

Set oSH = CreateObject("WScript.Shell")

oSH.RegWrite "HKEY_CURRENT_USER\Software\Tracker Software\PDF-XChange 3.0\Drivers\Control\Result.FileName", "", "REG_SZ"
oSH.RegWrite "HKEY_CURRENT_USER\Software\Tracker Software\PDF-XChange 3.0\Drivers\Control\State", "", "REG_SZ"

sFile = ""
sState = ""

while (sFile = "" or sState <> "Saved")

ActiveDocument.GetApplication.Sleep 100
sFile = oSH.RegRead ("HKEY_CURRENT_USER\Software\Tracker Software\PDF-XChange 3.0\Drivers\Control\Result.FileName")
sState = oSH.RegRead ("HKEY_CURRENT_USER\Software\Tracker Software\PDF-XChange 3.0\Drivers\Control\State")
wend

set oSH = nothing

set oFS = CreateObject("Scripting.FileSystemObject")
oFS.MoveFile sFile, sDestination
set oSH = nothing

end function

Just calling this function using the report name and the desired destination file name as parameters you will get the PDF right away.

Hope it helps !

Cheers

Qlikview PDF in 9

Mon, 31 May 2010 04:47:27 GMT

Hi, Eduardo

Thanks for the suggestion.

Will try it out later.

Qlikview PDF in 9

Wed, 08 Sep 2010 15:26:20 GMT

I'm having a problem with implementing Eduardo's solution. Im using v9 SR5 and this doesn't seem to work for me. When I press the button nothing happens. I have PDF-XChange 3.0 that was installed alongside with qlikview

Qlikview PDF in 9

Thu, 09 Sep 2010 02:24:23 GMT

Hi,

I just found out that bullzippdf is quite good and providing great compatibility to the latest qlikview applications.

Here is the code used for pdf generation. You may find the bullzippdf online + ghost script, i will not provide url here.

Sub printPDF

vReport = "RP01" 'Set report

vName = "myReport" 'Name of output pdf

ActiveDocument.PrintReport(vReport), "Bullzip PDF Printer", false 'Printreport

reportFile = ReportFolder & vName &".pdf" 'Setting outputname

MyPrintPDFWithBullZip(reportFile) 'Call pdf printer

End sub

FUNCTION MyPrintPDFWithBullZip (pdfOutputFile)

set obj = CreateObject("Bullzip.PDFPrinterSettings")
obj.SetValue "Output" , pdfOutputFile
obj.SetValue "ConfirmOverwrite", "no"
obj.SetValue "ShowSaveAS", "never"
obj.SetValue "ShowSettings", "never"
obj.SetValue "ShowPDF", "no"
obj.SetValue "RememberLastFileName", "no"
obj.SetValue "RememberLastFolderName", "no"
obj.SetValue "ShowProgressFinished", "no"
obj.SetValue "ShowProgress", "no"
obj.WriteSettings True

END FUNCTION

Regards

Mingming

Qlikview PDF in 9

Thu, 23 Sep 2010 11:28:12 GMT

Hi,

try to put the call to the printer after the while.

In this way it works fine in my case.

Qlikview PDF in 9

Thu, 23 Sep 2010 11:29:31 GMT


mremisze wrote:
I'm having a problem with implementing Eduardo's solution. Im using v9 SR5 and this doesn't seem to work for me. When I press the button nothing happens. I have PDF-XChange 3.0 that was installed alongside with qlikview<div></div>

Hi,

try to put the call to the printer after the while.

In this way it works fine in my case.

Qlikview PDF in 9

Thu, 23 Sep 2010 11:31:49 GMT


ste.san wrote:
Hi,
try to put the call to the printer after the while.
In this way it works fine in my case.
 <div></div>

Sorry for multiple post... Mistake, try yo put the call BEFORE the while

Qlikview PDF in 9

mountaindude — Mon, 24 Jan 2011 14:54:46 GMT

I have Eduardo's code in the OnPostReload trigger in a document. It works great when the reload is done from within the qv.exe client, with the full GUI etc.

But when doing a "qv.exe /r abc.qvw" the call to ActiveDocument.PrintReport fails. Anyone else seen this? Any possible solution? I have a fully paid for version of PDF XChange, so that shouldn't be an inssue.

Could it be that PDX XChange needs a UI environment to work properly? Just speculating here..

Qlikview PDF in 9

Mon, 24 Jan 2011 15:16:02 GMT

Hi G,

Try to use /l instead of /r in your batch file as a qlikview document needs to exist in order to use the activedocument call in your macro. /r only instantiates the scripting dialog and not an instance of Qlikview.

Kind Regards,

Footsie

Qlikview PDF in 9

Tue, 25 Jan 2011 01:52:31 GMT

If you want to achieve automation of pdf printing, put the pdf printing function in 'OnPostReload' and trigger the reload using /r will not get the pdf printed, because the pdf printing requires the existence of QV.exe while printing (Similar as the normal printer printings).

The Qv.exe will exit immediately when the reload completes, and therefore, the 'OnPostReload' to trigger pdf print will not work.

There were quite a number of posts discussing the pdf printing for a while, no practical suggestions have been given on putting pdf printing @ 'OnPostReload'.

Majority of the suggestions are to put pdf printing trigger @ 'OnOpen' and call the /r reload 2 times. 1st time reload data, 2nd time print pdf @ 'OnOpen'.

Hope above clarifies.