Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wandapec
Partner - Contributor III
Partner - Contributor III

Export to PDF - Doesn't save PDF

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

14 Replies
Not applicable

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?



Not applicable

Hi,

I'm facing exaclty the same problem with win 7. deactivated uac -> no change 😞

Anyone a solution?
Thanks in advance.

nathanfurby
Specialist
Specialist

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:

  • After installing the QlikView PDF Writer (Version 9) you should have a new pdf printer available in 'Printers and Faxes'
  • Right Click on the 'PDF-Xchange 3.0' printer and select 'Properties'
  • On the 'General' tab select 'Printing Preferences'
  • You can then set options as follows:

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.

Anonymous
Not applicable

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.

nathanfurby
Specialist
Specialist

Thanks for confirming Michael. Without the ability to download the 'original' QlikView PDF Writer I wasn't 100% sure how it used to work.