topic Macro export Reports to multiple PDF in QlikView

Macro export Reports to multiple PDF

thierrytt1102 — Mon, 13 Feb 2012 09:17:35 GMT

Hi all,

May I ask you to help me for a problem. This might be easy but I didn't studied comuting science.

I'd like to export my report RP01 to PDF files. But I don't want one pdf file for all the values. I'd like to have one pdf for one value (let's say the Region)

So I made my researches on this forum but couldn't find a simple code that loops all my values for printing my report RP01. The result of the macro sould be something like this:

in C:/QlikViewReports

RP01_Brazil.pdf

RP01_USA.pdf

RP01_France.pdf

...

I'm using PDF Creator and a personal version of QV11.

I found how to print some objects to pdf by looping values but not reports.

Thank you very much for your help!

T T

Macro export Reports to multiple PDF

stephencredmond — Mon, 13 Feb 2012 11:07:08 GMT

Hi Thierry,

Just for you, I wrote a new blog post:

http://qliktips.blogspot.com/2012/02/printing-reports-to-pdf-using.html

Actually, I have been meaning to write this one for a while so thanks for the nudge.

Regards,

Stephen

Macro export Reports to multiple PDF

thierrytt1102 — Mon, 13 Feb 2012 11:32:34 GMT

It is the first time I copy paste a code and it works directly. Thank you sooo much!

Macro export Reports to multiple PDF

thierrytt1102 — Mon, 13 Feb 2012 13:30:59 GMT

Hi Stephen,

I just had a question. How do you call that macro with a button?

If you "add button" that runs a Macro and you specify the name of a Macro, QV doesn't recognize

Print_PDF(FieldValue, ReportName, ReportID)

as it is probably too long.

I created a macro called Printopdf that calls your macro but there is like a bug in QV, the macro is executed two times!

Thank you

Macro export Reports to multiple PDF

stephencredmond — Mon, 13 Feb 2012 14:13:04 GMT

Hi Thiery,

In a macro, I would normally have all the get values and looping in one sub (e.g. called "PrintReport()") and then this one calls print_PDF. The button doesn't allow parameters so you can only call a macro that doesn't have parameters.

Regards,

Stephen

Macro export Reports to multiple PDF

thierrytt1102 — Tue, 08 May 2012 07:48:44 GMT

Hi Stephen,

Let me come back to you concerning the macro. I have a problem that I can't solve. When printing more than 400 pdf reports that contains multiple objects, I mentioned that, after around 200 printings, PDF creator starts printing while Qlikview doesn't have time to display the object.

Result: from the 200th report, an object is always missing.

I can see "live" that this object appears less than 1 second (while printing) after the start of the printing process.

I tried to put a sleep time but it is not working.

Any ideas?

Thank you very much.

Macro export Reports to multiple PDF

stephencredmond — Tue, 08 May 2012 16:27:17 GMT

Hi Thierry,

Sorry, I haven't taken this macro up to that number of PDFs.

Does it make a difference on a desktop or a server?

Can you split it down to smaller groups?

Regards,

Stephen

Macro export Reports to multiple PDF

thierrytt1102 — Tue, 08 May 2012 18:40:16 GMT

Hi Stephen,

Thanks for your support.

For the moment, I'm using a desktop version, I can't test it as we're mainly developping BO projects. We're just starting with QV.

Interesting suggestion;

I've split the macro : 1: from record 1 to 150

2: from record 151 to 300

If I execute 1 then 2 without exiting QV, I still have the problem

If I close QV after the job of the first macro and restart it for the second one, it is working fine.

😕

Cheers,

T T

Macro export Reports to multiple PDF

thierrytt1102 — Fri, 11 May 2012 08:36:47 GMT

Hi Stephen,

It seems QV is storing the selection each time it select the value.

After a lot of selections, there is like an "history" to clear. Do you know a way to force QV not to save the selection value each time?

Thx

Re: Macro export Reports to multiple PDF

davdiste — Fri, 23 Jan 2015 16:06:47 GMT

Hi Stephen,

I read your post on

http://qliktips.blogspot.com/2012/02/printing-reports-to-pdf-using.html

The macro also works with 64-bit OS?

Thx

cheers

Davide

Re: Macro export Reports to multiple PDF

stephencredmond — Sun, 25 Jan 2015 20:09:43 GMT

Yes. I use 64bit OS all the time.

Re: Macro export Reports to multiple PDF

davdiste — Mon, 26 Jan 2015 10:25:29 GMT

Hi Stephen,

I’ve tried to implement the macro directly within Qlik, but it doesn't work.

Probably I've made some mistakes because I'm not very familiar with vb.

Anyway, you can find below your macro highlighting in bold the parts I’d like to change.

May you please have a look if I should change something else?

Thanks, Davide

    Dim FieldName
        FieldName = "Seg"
    set mySelections = ActiveDocument.Fields(FieldName).GetPossibleValues

    Dim i
for i = 0 to mySelections.Count - 1
Dim FieldValue
FieldValue = mySelections.Item(i).text

        ActiveDocument.Fields(FieldName).Select FieldValue
Print_PDF FieldValue, "My Report", "RP01"
    Next

Sub Print_PDF(FieldValue, ReportName, ReportID)
' Designed for early bind, set reference to PDFCreator
    Dim pdfjob
    Dim sPDFName
    Dim sPDFPath

    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
ActiveDocument.PrintReport ReportID, "PDFCreator"

Do Until pdfjob.cCountOfPrintjobs = 1

ActiveDocument.GetApplication.Sleep 20

' in VBScript use WScript.Sleep(20)

Loop

pdfjob.cPrinterStop = False

Do Until pdfjob.cCountOfPrintjobs = 0

ActiveDocument.GetApplication.Sleep 20

' in VBScript use WScript.Sleep(20)

Loop

pdfjob.cClose

Set pdfjob = Nothing

End Sub

ActiveDocument.PrintReport ReportID, "PDFCreator"

Re: Macro export Reports to multiple PDF

stephencredmond — Mon, 26 Jan 2015 11:33:49 GMT

Where, exactly, is it stopping working?

Re: Macro export Reports to multiple PDF

davdiste — Mon, 26 Jan 2015 11:46:49 GMT

Set pdfjob = CreateObject("PDFCreator.clsPDFCreator")

Re: Macro export Reports to multiple PDF

stephencredmond — Mon, 02 Feb 2015 15:22:47 GMT

Did you install PDFCreator?

Re: Macro export Reports to multiple PDF

Anonymous — Thu, 19 Feb 2015 12:28:42 GMT

Could this be a case of PDFCreator 2.0?

http://forums.pdfforge.org/discussion/30741/pdfcreator-2-0-vbscript-support

Kind regards

Niklas

Re: Macro export Reports to multiple PDF

davdiste — Thu, 19 Feb 2015 17:10:00 GMT

Thanks Stephen and Nicklas,

I've verified and the version of PDF creator is the 2.0.2.

I'll look for a precedent version and I'll try again.

Bye
Davide

Re: Macro export Reports to multiple PDF

davdiste — Tue, 24 Feb 2015 17:32:41 GMT

Hi,

With PDF creator 1.0 it works.

Thanks a lot!

Davide

Re: Macro export Reports to multiple PDF

thomas_skariah — Tue, 06 Jun 2017 02:50:43 GMT

Hi Stephen,

I'm using this macro to extract one of the report to multiple pdf, although the reports are generated here, but I'm facing one issue, the macro gets executed when I'm going to edit module without pressing any button or any trigger.

Regards,

Tom