topic Re: Automating PDF reports creation? in QlikView

Automating PDF reports creation?

Thu, 11 Apr 2013 08:17:04 GMT

Hi all,

Just wondering if anyone can advise....

I have Qlikview installed on my computer. I have created a set of dashboards for which I would now like to create pdf files from. For each pdf file, I would like to select a specific value within a dimension. I know I can do this manually but I would like to automate this whole process. So for example, say I have an 'Employee Name' dimension that has 100 different employee names. I would like to automate the creatation of pdfs, one pdf file per employee name (in this example it would be 100 pdf files).

Can this be done/automated within Qlikview? Or do I need something like Publisher?

Regards

Revlin

Re: Automating PDF reports creation?

Anonymous — Thu, 03 Oct 2013 20:05:38 GMT

The short answer is "Yes", you can do it from a QlikView developer client.

To make it simple, let's say you have a report with the objects you want to print to PDF looping through possible values in a field (it's almost the same if you want to print an object directly rather than via a report).

You write a macro that

1) Edits the registry to suppress the Print dialogue, e.g. using QlikViewPDF, search WSHShell.RegWrite in the community

2) Get possible values of the desired field, "Employee Name"

3) Loops through the values one by one, while

a) selects the value in Employee Name

b) creates a path and filename to where the pdf is stored, probably including your Employee Name

c) write to registry the path\filename created in b) to print registry

d) print report by PrintDocReport or other report print command, see APIGuide or community

Next Employee...

Hope this puts you on the right track.

/Nicolai

Re: Automating PDF reports creation?

vikasmahajan — Fri, 04 Oct 2013 12:13:58 GMT

PFA application and you can mail to employees.

Vikas

Re: Automating PDF reports creation?

Anonymous — Fri, 04 Oct 2013 18:23:30 GMT

Also see this, using QLikViewPDF and Bullzip: QlikView Makro PDF Print with BullZip PDFCreator QlikViewPDF » BEEYE

Re: Automating PDF reports creation?

Tue, 14 Jan 2014 17:43:43 GMT

Hi Vikas,

I have BullZip Printer Installed on my machine.

I downloaded your document (qvw) file.

But somehow the macro in it seems to print just one specific chart (Issues by Module) in it.

It does not run when i change the report ID from RP01 to something else.

And one more question : The chart that gets successfully printed has ID CH01 and not RP01. But still the macro prints this chart. Howz that possible ?

Thanks in Advance

Sagar

Re: Automating PDF reports creation?

Tue, 14 Jan 2014 18:25:28 GMT

I already did something close to what you want, but in my case I was sending the pdf files by email. I will put a little part of my macro code to you get the idea.

Sub sendPDFByMail

myFieldName = "sample"

fileName = "PDFSample"

createTempFolder "C:\TempQlikView\"

generateDate formattedDate

Set possibleValues = ActiveDocument.Fields(myFieldName).GetPossibleValues

For i = 0 To possibleValues.Count - 1

ActiveDocument.Fields(myFieldName).Clear

ActiveDocument.Fields(myFieldName).Select possibleValues.Item(i).Text

generatePDFFile fileName & possibleValues.Item(i).Text, formattedDate

sendMail fileName & possibleValues.Item(i).Text, formattedDate

MsgBox("Emails send")

deleteTempFolder("C:\TempQlikView\")

End If

End Sub

Re: Automating PDF reports creation?

Wed, 15 Jan 2014 15:10:07 GMT

Hi All ,

I have been able to create PDF Reports using a macro that i found in one of the blogs.

But i have one more question : Does every user need to install the 3rd party PDF printer (BullZip Printer or QlikViewPDF) on his/her system or just installing it on the server would do the job?

Thanks in Advance.

Sagar

Re: Automating PDF reports creation?

Anonymous — Wed, 15 Jan 2014 15:18:21 GMT

The machine running the macro, altering registry, creating the pdfs, need the pdf printer driver.

Did you get automation to work on the server? Just curious...

Re: Automating PDF reports creation?

Wed, 15 Jan 2014 15:40:11 GMT

I havent yet tried it on the server. But it works just fine on my client. Will keep you posted about after trying it.

Re: Automating PDF reports creation?

nizamsha — Wed, 15 Jan 2014 16:09:45 GMT

I guess Excatly what u want PFA.