topic Re: Document Report Saving in PDF using VB script in QlikView

Document Report Saving in PDF using VB script

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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,

beck_bakytbek — Fri, 14 Oct 2016 13:25:01 GMT

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 — Fri, 14 Oct 2016 16:34:25 GMT

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

hope this helps

Anonymous — Mon, 17 Oct 2016 06:12:01 GMT

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