how to save a qlikview generated report

[#1]

Hi,

i have used the reports function in Qlikview which allows you to generate a report of certain graphs and charts from your dashboard so you can print them out automatically from the tool.

However my question is how can you save these reports to save a PDF?

thanks

Laura

[#2]

Hi Ram,

I am Using PrimoPDF writer not QlikviewPDF. still i ran your macro but getting below exception.

Type mismatch: 'printReportPDF'

Thanks,

chandra

[#3]

Dear Chandra,

Pls send u r macro

Regards,

Chandu

[#4]

Hi Ram,

Here is the macro.

sub a

ActiveDocument.clearall
path="C:\"
'path="D:\Qlikview\Report\"
ActiveDocument.PrintDocReport ("RP01"),"PrimoPDF", false
set rep = ActiveDocument.GetReport("RP01")
reportFile = path & "MIBL_Snapshot"&".pdf"
PrintreportPDF(reportFile)

ActiveDocument.GetApplication.Sleep 12500

end sub

when i ran macro it is calling PrimoPDF along with expection but still it is pumping savea as popup window. plz find the attached screenshot.

Thanks,

Chandra

[#5]

Dear Chandra pls Find and change the paths  and rpno

sub a

ActiveDocument.clearall
path="\\inmchn24\ChannelMIS\Centrlal MiS\Daily Reports\Automated Reports\"
'path="D:\Qlikview\Report\"
ActiveDocument.PrintDocReport ("RP39"),"QlikViewPDF", false
set rep = ActiveDocument.GetReport("RP39")
reportFile = path & "MIBL_Snapshot"&".pdf"
printReportPDF(reportFile)

ActiveDocument.GetApplication.Sleep 12500
end sub

ActiveDocument.Save
ActiveDocument.GetApplication.Quit

Function printReportPDF(pdfOutputFile)
Set WSHShell = CreateObject("WScript.Shell")
WSHShell.RegWrite "HKCU\Software\QlikViewPDF\OutputFile", pdfOutputFile, "REG_SZ"
WSHShell.RegWrite "HKCU\Software\QlikViewPDF\BypassSaveAs", "1", "REG_SZ"
Set WSHShell = nothing
End function

[#6]

Hi Ram,

Thanks for your support.

still it's not working to auto save the file, same Pop up i was getting. This macro mitght work only if i have QlikviewPDF writer installed. I tried to get VB code for PrimoPDF in google but there is no solution. Many Questions on PrimoPDF with out answers in Web.

Really this one is eating my brain!!

Regards,

Chandra

[#7]

ActiveDocument.PrintDocReport ("RP39"),"QlikViewPDF", false 

pls replase ur primo pdf in the place of QlikViewPDF

[#8]

Hi Ram,

I tried but no luck.

Thanks,

Chandfra

[#9]

hello all,

i have never used macro's with QV before, i am trying to set up an automated save for a report and i am hoping you can help me with a few basic questions.

first of all i know this is a silly question but where do i put the macro syntax? do i put it in with the qvw code?

also if you can give me a quick explanation on the macro syntax that will be great.

thanks in advance.