Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Document Report Saving in PDF using VB script

hi All,

I have written below code, for opening the QV document outside QlikView and also to access report in it. -

Set Qv = CreateObject("QlikTech.QlikView")

Qv.Launch "C:\Program Files\QlikView\qv.exe", "Asset Management.qvw"

Set docObj = Qv.OpenDoc("Asset Management.qvw", 3, False)

docObj.Reload

docObj.Save

path="D:\Qlik\"

set rep = docObj.GetReport("RP01")

reportFile = path & "test"&".pdf"

printReportPDF(reportFile)

docObj.GetApplication.Sleep 12500

docObj.CloseDoc

Set docObj = Nothing

Set Qv = Nothing

I am not able to save the Report using the same code as a PDF in particular path.

When we print the QlikView Document Report, it automatically creates the PDF for same, I want to do the same thing, using a VB script.

the Reload and Save option is also not working.

Can anyone please let me know how to achieve same.

Thanks & Regards,

MK

3 Replies
beck_bakytbek
Master
Master

Hi Mrudul,

check this: QlikTip #32: Exporting multiple QV objects to a single Excel document in this Forum you can find an Information that resolves your issue.

i hope that helps

beck

Frank_Hartmann
Master II
Master II

have a look here. this might be the solution for you:

Re: Automated pdf reports

hope this helps

Anonymous
Not applicable
Author

Thanks for both the post.

I also have to implement security on top reloading task of QlikView.

The username and password will come from URL to vbscript