Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there, I have been at this for days. I need to save a report to a specified file etc. The simplest script I can get from other numerous examples is this -
sub printRP01
printReportPDF "C:\TestPDF\myreport.pdf"
ActiveDocument.PrintReport "RP01", "QlikviewPDF", false
end sub
Function printReportPDF(pdfOutputFile)
Set WSHShell = CreateObject("WScript.Shell")
WSHShell.RegWrite "HKCU\Software\QlikviewPDF\OutputFile", pdfOutputFile, "REG_SZ"
WSHShell.RegWrite "HKCU\Software\QlikviewPDF\BypassSaveAs", "1", "REG_SZ"
Set WSHShell = nothing
End function
I have tried all sorts of variations of this but it just won't save RP01 to myreports.pdf in C:\TestPDF.
Please help?
Thanks Steve
Hi,
I have the same exactly the same problem. The PDFdriver seems to print, but the file is not saved in the any director.
I use Vista full upgraded. Sometimes ago I used the same file on my computer and it worked.
Also, I have tried the file on other computers (Win Serv 2008 and XP) and it work perfectly.
Any idea?
Hi,
I'm facing exaclty the same problem with win 7. deactivated uac -> no change 😞
Anyone a solution?
Thanks in advance.
I have been wondering about this for a few weeks. No one seems to be able to confirm - but I think the "QlikView" pdf writer has changed since other forum members started writing the code involving registry key changes. I have recently installed both version 7 and 9 of the PDF Writer from the QlikView website and neither seems to use the registry keys mentioned.
My workaround so far has been this:
As you can see, you can specify the Path that the pdf files will be saved to. Ignore the File Name/Macro settings - these will not work. Instead, you will have to rename the files on the fly in your QV Macro using the file system object. You can do this because the pdf printer will always output the file as 'QlikView Printing.pdf'.
So instead of modifying registry keys my macro function now looks like this:
Function printReportPDF(oReport, pdfOutputFile)
ActiveDocument.PrintReport oReport, "PDF-XChange 3.0", false
Set objFSO = CreateObject("Scripting.FileSystemObject")
objFSO.MoveFile "C:\Temp\QlikView Printing.pdf" , pdfOutputFile
End Function
Where 'oReport' is the name of the report in QV to be printed and pdfOutputFile is the full path and name of the pdf file to be created.
Nathan,
You'r right. Previously QlikViewPDF was based on CutePDF writer (I think so), and now it is replasced with PDF-XChange 3.0. So, the old solutions are not applicable any more.
Thanks for confirming Michael. Without the ability to download the 'original' QlikView PDF Writer I wasn't 100% sure how it used to work.