Report to PDF format using macro

[#1]

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 !

[simospa]

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?

S.

[#3]

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

[vikasmahajan]

Dear Robin

Please go through following link  EMAIL_MACRO

Sending Emails using Macro

Please let me know any further assistance required.

Vikas

[#5]

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

[vikasmahajan]

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

[#7]

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 

[vikasmahajan]

What more assistance you are looking for ??

Vikas

[#9]

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

[vikasmahajan]

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

Thanks

Vikas