topic Export a pdf. in QlikView

Export a pdf.

Thu, 30 Sep 2010 19:34:01 GMT

Hi all, I want to export pdf but i'm having a problem because the code i'm using print the pdf and export it. I only want to export....

Here is the code:

set WSHShell = CreateObject("WScript.Shell")
WSHShell.RegWrite "HKCU\Software\QlikViewPDF\OutputFile", "E:\util\MailQV\Cohortes.PDF", "REG_SZ"
WSHShell.RegWrite "HKCU\Software\QlikViewPDF\BypassSaveAs", "1", "REG_SZ"
ActiveDocument.PrintReport "RP01", "QlikviewPDF", false
set WSHShell = nothing

Thanks!!

Export a pdf.

pkelly — Thu, 30 Sep 2010 19:57:52 GMT

I do the following....

sub printRP01
printReportPDF "C:\QlikViewDocuments\Timbmet_PDF\18T.pdf"
ActiveDocument.GetApplication.Sleep 2000
ActiveDocument.PrintReport "RP01", "QlikviewPDF"
ActiveDocument.GetApplication.Sleep 10000
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 a button which calls the macro "printRP01"...

Regards

Paul

Export a pdf.

pkelly — Thu, 30 Sep 2010 19:59:27 GMT

Forgot to add...

I downloaded the QlikView PDF printer - available from downloads

Export a pdf.

Thu, 30 Sep 2010 20:15:02 GMT

Thanks for your reply, Where can i download the qlikviewPDF. I have it install but i will download again.

I'm going to http://global.qlik.com/download/ but I don't find this.

Export a pdf.

Thu, 30 Sep 2010 20:38:18 GMT

I have tested but id did the same. It's printing the pdf. Do you know other way yo export only???

Tkss

Export a pdf.

Mon, 04 Oct 2010 17:50:15 GMT

I used pdfcreator in my app.

// Create instance of PDFcreatore

Set PDFCreator = CreateObject("PDFCreator.clsPDFCreator")

PDFCreator.cOption("UseAutosave") = 1 // Enable autosave

PDFCreator.cOption("UseAutosaveDirectory") = 1 // Use a specific save directory

PDFCreator.cOption("AutosaveDirectory") = ActiveDocument.getVariable("TempPath").GetContent.String // Set autosave directory

PDFCreator.cOption("AutosaveFormat") = 0 // Use PDF file type (.PDF extension)

PDFCreator.cOption("AutosaveFilename") = "My PDF" // set the filename, optionally you can get the Caption of the object and use it as Filename

PDFCreator.cPrinterStop = FALSE

// Export to PDF File

ActiveDocument.PrintDocReport ReportID, "PDFCreator"

Export a pdf.

Tue, 05 Oct 2010 19:57:40 GMT

Thanks Glen, it's working for me. But I have a problem. I have instaled PDFCreator en the server as a service. But when i try to run the macro via web on the client i have an error because I don't have in the client's machine the pdfcreator install.

How are you working???

Thanks a lot!!

Export a pdf.

suniljain — Fri, 25 Feb 2011 06:43:12 GMT

Dear Glenn,

I get following error whem using your code.

ActiveX component can't create object: 'PDFCreator.clsPDFCreator'

Regards

Sunil;

Export a pdf.

suniljain — Fri, 25 Feb 2011 07:19:42 GMT

Execution Stop on following line

'Export to PDF File

ActiveDocument.PrintDocReport ReportID, "PDFCreator"

Export a pdf.

Fri, 25 Feb 2011 07:38:01 GMT

Dear Sunil,

Use the following line
ActiveDocument.PrintDocReport "RP01", "PDFCreator"

Export a pdf.

suniljain — Fri, 25 Feb 2011 07:48:40 GMT

Dear Kumar,

I alredy use the same that you suggest although execution stop there.

Export a pdf.

Fri, 25 Feb 2011 07:56:09 GMT

I tried the same and found no issues.
Try this:

Sub Createpdf
Set PDFCreator = CreateObject("PDFCreator.clsPDFCreator")
PDFCreator.cOption("UseAutosave") = 1 ' Enable autosave
PDFCreator.cOption("UseAutosaveDirectory") = 1 ' Use a specific save directory
PDFCreator.cOption("AutosaveDirectory") = "C:\Test\"' ActiveDocument.getVariable("TempPath").GetContent.String ' Set autosave directory
PDFCreator.cOption("AutosaveFormat") = 0 ' Use PDF file type (.PDF extension)
PDFCreator.cOption("AutosaveFilename") = "My PDF" ' set the filename, optionally you can get the Caption of the object and use it as Filename
PDFCreator.cPrinterStop = FALSE
' Export to PDF File
ActiveDocument.PrintDocReport "RP01", "PDFCreator"

End Sub

Export a pdf.

Fri, 25 Feb 2011 08:30:30 GMT

Dear Matytr21,

Take this Macro and Paste in Your VBScript and Try, and You have to use QVPDF Install it ,you can Download it from QlikView Website, It will Work Fine, Just Select Your Default Printer as CudePDF it will Export PDF File Will Noy Print it.

sub printReport_MktEval
set oReportsId = ActiveDocument.Fields("ReportID").GetPossibleValues
set RepName=ActiveDocument.Fields("ReportValue").GetSelectedValues
if(RepName.count=1) then
dim id
id=oReportsId.Item(0).Text
ActiveDocument.PrintReport id
else
msgbox ("Please select a Report")
end if
end sub

Regards,

Pranav

Export a pdf.

suniljain — Fri, 25 Feb 2011 08:42:17 GMT

Dear Kumar,

Thanks lot for quick response

but I get error which showns in screenshot.

Export a pdf.

Fri, 25 Feb 2011 09:52:54 GMT

Dear Sunil,

Can you Explain y? u are getting Error means what you have written in Macro.

Regards,

Pranav

Export a pdf.

suniljain — Fri, 25 Feb 2011 11:20:53 GMT

Thanks Pranav,Kumar

Resolved the issue.

Export a pdf.

Tue, 21 Jun 2011 12:51:16 GMT

Sunil Jain ha scritto:
Dear Glenn,
I get following error whem using your code.
ActiveX component can't create object: 'PDFCreator.clsPDFCreator'
Regards
Sunil;

Hi, i have your same problem, how do you resolve it?

thanx

Export a pdf.

suniljain — Tue, 21 Jun 2011 18:06:13 GMT

Dear Pranav,

if you donot create report and directly try to create PDF in that case you will get that types of Error.

Re: Export a pdf.

Wed, 22 Jun 2011 07:21:34 GMT

Sunil Jain ha scritto:
Dear Pranav,
if you donot create report and directly try to create PDF in that case you will get that types of Error.

Hi Sunil,

i've already create report RP01 when i call this macro, but it doesn't works. It stop at line 2: Set PDFCreator = CreateObject("PDFCreator.clsPDFCreator")

this is my script:

sub createPDF

Set PDFCreator = CreateObject("PDFCreator.clsPDFCreator")

PDFCreator.cOption("UseAutosave") = 1

PDFCreator.cOption("UseAutosaveDirectory") = 1

PDFCreator.cOption("AutosaveDirectory") = "C:\Users\Public\Documents\TestQlik\PreviousPeek\Test"

ActiveDocument.getVariable("TempPath").GetContent.String

PDFCreator.cOption("AutosaveFormat") = 0

PDFCreator.cOption("AutosaveFilename") = "My PDF"

PDFCreator.cPrinterStop = FALSE

ActiveDocument.PrintDocReport "RP01", "PDFCreator"

end sub

Can you look at my qvw? It is very simple. I use QlikView 10 SR2 64bit and i've installed PDFCreator 1.2.1

Thanks

Export a pdf.

Tue, 14 Feb 2012 20:36:29 GMT

Did you ever resolve this issue?

Alex