topic Re: Generate PDF report in QlikView

Generate PDF report

Mon, 25 Jan 2016 13:41:10 GMT

i want to generate a report using macro and store it in the PDF format.

the report should contain the screen shot of the activated sheet

and that screenshot should be save in PDF format.

Thanks in advance

Re: Generate PDF report

andrespa — Mon, 25 Jan 2016 17:32:19 GMT

Hi Nishit, something like this should works:

Sub Print_PDF(FieldValue, ReportName, ReportID)

' Designed for early bind, set reference to PDFCreator

Dim pdfjob

Dim sPDFName

Dim sPDFPath

'/// Change the output file name here! ///

sPDFName = ReportName & " - " & FieldValue

sPDFPath = "C:\PDFReports"

Set pdfjob = CreateObject("PDFCreator.clsPDFCreator")

With pdfjob

If .cStart("/NoProcessingAtStartup") = False Then

If .cStart("/NoProcessingAtStartup", True) = False Then

Exit Sub

End if

.cVisible = True

End If

.cOption("UseAutosave") = 1

.cOption("UseAutosaveDirectory") = 1

.cOption("AutosaveDirectory") = sPDFPath

.cOption("AutosaveFilename") = sPDFName

.cOption("AutosaveFormat") = 0 ' 0 = PDF

.cClearCache

End With

' Print the QlikView Report

ActiveDocument.PrintReport ReportID, "PDFCreator"

'Wait until the print job has entered the print queue

Do Until pdfjob.cCountOfPrintjobs = 1

ActiveDocument.GetApplication.Sleep 20

' in VBScript use WScript.Sleep(20)

Loop

pdfjob.cPrinterStop = False

'Wait until PDF creator is finished then release the objects

Do Until pdfjob.cCountOfPrintjobs = 0

ActiveDocument.GetApplication.Sleep 20

' in VBScript use WScript.Sleep(20)

Loop

pdfjob.cClose

Set pdfjob = Nothing

End Sub

For your second part of the question, in your reports you can include a text box and put the method "GetActiveSheetId()". That will show you the current active sheet.

For more details in the mcro, please go to this link:

Qlik Tips: Printing Reports to PDF using PDFCreator

Hope it helps.

Cheers,

Andrés

Re: Generate PDF report

Wed, 27 Jan 2016 04:50:36 GMT

hi andres,

thanks for the reply

but i didn't created any report using report toolbar which given in qlikivew

i want to create the dynamic report using macro

the report include charts dynamically using macro...\

any suggestion on that

Re: Generate PDF report

jonathandienst — Wed, 27 Jan 2016 05:20:09 GMT

I don't think that it is possible to do that in a macro. Have a look at nPrinting for this purpose. Search here for more information on nPrinting.

Re: Generate PDF report

vikasmahajan — Wed, 27 Jan 2016 05:38:53 GMT

N-printing is better option for you as Jonathan said.

Vikas

Re: Generate PDF report

tamilarasu — Wed, 27 Jan 2016 05:58:17 GMT

Hi Nishit,

I don't have PDF software in my system, so I just tried to export the screenshot to Word format (But you can modify the macro). Hope this is what you are asking.

Re: Generate PDF report

Wed, 27 Jan 2016 06:13:33 GMT

hi nagraj,

thanks for the reply

but its giving an error

ActiveX component can't create object: 'Word.Application'

any suggestion on this

Re: Generate PDF report

HirisH_V7 — Wed, 27 Jan 2016 06:21:18 GMT

Hi may be like this,

Got to Reports-> first create a report of with all objects you need on a report ,

Create a report:

Reports -> Edit report-> Add Report -> There open the Report and drag and drop all of your required Objects -> Such that all will be on that report.

Macro to call Report :

Download Primo PDF and Install it,

Then use this macro-

Sub PDFExport


ActiveDocument.clearall
path="C:\"
'path="D:\Qlikview\Report\"
ActiveDocument.PrintDocReport ("RP01"),"PrimoPDF", false
set rep = ActiveDocument.GetReport("RP01")
reportFile = path & "MIBL_Snapshot"&".pdf"
PrintreportPDF(reportFile)


ActiveDocument.GetApplication.Sleep 12500


end sub

By running this Macro you will get a pop up from like this,

There you can save your PDF.

Hope this Helps,

PFA,

Hirish

Re: Generate PDF report

HirisH_V7 — Wed, 27 Jan 2016 08:45:29 GMT

HI,

Check this,

-Hirish

Re: Generate PDF report

tamilarasu — Wed, 27 Jan 2016 09:24:12 GMT

Nishit,

You need to change the current local security level as "Allow system access". Press Ctrl + M and change the security level like below

Or you can press Ctrl + Shift + M and change the selection to "Give System Access to Module Security".

Re: Generate PDF report

Wed, 27 Jan 2016 09:30:43 GMT

it already on Allow System Access

but then also its giving an error

ActiveX component can't create object: 'Word.Application'

Re: Generate PDF report

amit_saini — Wed, 27 Jan 2016 09:31:46 GMT

Nishit,

PFA

Thanks,
AS

Re: Generate PDF report

Wed, 27 Jan 2016 09:37:33 GMT

PDF File is not Genating

Re: Generate PDF report

Anonymous — Wed, 27 Jan 2016 09:47:49 GMT

If you create PDF Report using Edit Report then it would resolve your problem

Re: Generate PDF report

HirisH_V7 — Wed, 27 Jan 2016 10:48:45 GMT

Does Microsoft office is opening or not .Please check once !!

Re: Generate PDF report

Wed, 27 Jan 2016 11:13:44 GMT

ya its opening