topic Re: Report to PDF format using macro in QlikView

Report to PDF format using macro

Fri, 03 Jul 2015 08:25:29 GMT

Hi Team,

I have a requirement to export a QlikView Dashboard to a PDF report format, one document opening using macro's and triggers.

Kindly let me know, the appropriate steps to be carried out the achieve the same and it would be great if anyone can provide the respective macro, so that I can acknowledge the same and add it to my knowledge base.

Current dashboard composes of one charts and one straight table.

Any kind of help would be appreciated

Thanks !

Re: Report to PDF format using macro

simospa — Fri, 03 Jul 2015 09:02:48 GMT

Hi,

can't you use a Report and then a Button with native Print Report action, with Open Printer Dialog flag checked, and so the users can print it on a virtual PDF printer?

Re: Report to PDF format using macro

Fri, 03 Jul 2015 09:21:40 GMT

Hi Simone,

Thanks for your inputs.

Wish I could work out the way you suggested. But I need to get the PDF report generated using Macro, as per my business requirement.

Kindly provide your views incase w.r.t macro runs

Re: Report to PDF format using macro

vikasmahajan — Fri, 03 Jul 2015 09:25:37 GMT

Dear Robin

Please go through following link EMAIL_MACRO

Sending Emails using Macro

Please let me know any further assistance required.

Vikas

Re: Report to PDF format using macro

Fri, 03 Jul 2015 09:38:51 GMT

Hi Vikas,

Thanks! But my requirement is to create a 'PDF report' of my qlikview dashboard, when the 'user Opens' (i.e. On open document Trigger, PDF should be created) the respective dashboard.

Steps/Macro/Suggestion with respect to this will be very helpful.

Robin

Re: Report to PDF format using macro

vikasmahajan — Fri, 03 Jul 2015 11:23:06 GMT

Hii,

Robin you can create report in qlikview and paste all objects in reports through VB macros we can

generate the PDF file and distribute this pdf in user email box directly. This qvw you need to run from outside server using batch file , This batch file you have to schedule in task schedular for auto-matic run.

hope this may help you some !!

Regards

Vikas

Re: Report to PDF format using macro

Fri, 03 Jul 2015 12:35:06 GMT

Hi Vikas.

Thanks again.

But I have written a macro as required for pdf export and it worked for me.

Sub pdf_export

vReport = "RP01"

vName = "pdf_export.PDF"

ActiveDocument.PrintReport(vReport), "PDF-XCHANGE", false

reportFile = "c:\PDFs\Operations\" & vName &".pdf"

PDF-XCHANGE(X3reportFile)

ActiveDocument.GetApplication.Sleep 5000

ActiveDocument.Save

ActiveDocument.GetApplication.Sleep 5000

ActiveDocument.GetApplication.Quit

End sub

Re: Report to PDF format using macro

vikasmahajan — Tue, 07 Jul 2015 05:49:57 GMT

What more assistance you are looking for ??

Vikas

Re: Report to PDF format using macro

Wed, 08 Jul 2015 06:26:08 GMT

Hi Vikas,

Thanks, No more assistance required as of. Because I have written the above macro and it works well for me.

Have pasted the same in community, so that anyone else seeking for the same find it useful

Re: Report to PDF format using macro

vikasmahajan — Wed, 08 Jul 2015 06:34:56 GMT

If it is close please mark with correct answer and close thread.

Thanks

Vikas