topic Re: Re : Macro to generate PDF in QlikView

Re : Macro to generate PDF

Mon, 20 Jul 2015 11:08:30 GMT

Dear All,

Anyone please help me to fix the following issue:

i used to generate pdf reports through macro and it was running successfully. and it was triggered post reload. when i go to report--> print reports the pdf generation is happening using PDF exchange 3.0. But automation of PDf report generation by using QlikViewPDF is not working through Macro after the reload.

I checked devices and printer in control panel, there is no queue of tasks that is empty.

Whenever macro is running it is showing printing report in QlikViewPDF printer then application hangs.

kindly help me to fix the issue.

Re: Re : Macro to generate PDF

avinashelite — Mon, 20 Jul 2015 12:30:36 GMT

can you please share the macro code ?? check whether QlikViewPDF is installed and working properly

Re: Re : Macro to generate PDF

Mon, 20 Jul 2015 12:46:21 GMT

yes..when i do manually through Report->(ReportName)-->Print, i am able to do Generate the PDF Report.

Re: Re : Macro to generate PDF

avinashelite — Mon, 20 Jul 2015 12:55:39 GMT

I think the issue is with the Macro code ....check with that once ??

it should be something like this

Sub GWP_Macro4r_Email

'...........PDF Export logic.............QlikViewPDF

ActiveDocument.clearall
path="\\inmchn24\ChannelMIS\Centrlal MiS\Daily Reports\Automated Reports\"
'path="D:\Qlikview\Report\"
ActiveDocument.PrintDocReport ("RP01"),"QlikViewPDF", false
set rep = ActiveDocument.GetReport("RP01")
reportFile = path & "SRO_GWP_Dashboard"&".pdf"
printReportPDF(reportFile)

ActiveDocument.GetApplication.Sleep 16000

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

Re: Re : Macro to generate PDF

Wed, 22 Jul 2015 07:07:01 GMT

Dear Avinash,

The macro is working fine for more than a year the application is functioning and generating the report with the same macro code.

but suddenly one day it stopped working and manually the report can be generated.