Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Install a PDF printer driver such as PDFCreator.
-Rob
Do you have a link to download that off?
I use PrimoPDF
I've also used PDFCreator
Hi Rob,
Could you please suggest me how to bypass the save as pop up window for PrimoPDF writer since you were using PrimoPDFas PDF writer. if i want to save the file i have to lick on save as button manually but i want to automate instead of hitting manually. below is the code i was using
sub pdftest
set WSHShell = CreateObject("WScript.Shell")
WSHShell.RegWrite "HKCU\Software\PrimoPDF\OutputFile", "C:\Program Files\ActivePDF\PrimoPDF\QlikView Prin.pdf", "REG_SZ"
WSHShell.RegWrite "HKCU\Software\PrimoPDF\BypassSaveAs", "1", "REG_SZ"
ActiveDocument.PrintReport "RP01","PrimoPDF", false
set WSHShell = nothing
end sub .
Thanks,
Chandra
after Creating report
if you click on report name
Reports-> reportName-> click
it will ask you to print
then in Printer Name _> select PDF writer Name for ex PDFExchange 3.0
then print and save as ReportName.pdf
Hope this helps
Dear Member,
If u want to save generated pdf should save automaticcally into some path
is it u r Requirement
Thanks,
Chandu
Hi Ram,
Thank's for Quick reply!!
Yes, it has to save automatically to the specified location with out hitting manually on "OK" button.
I am using PrimoPDF as PDF writer.
Regards,
Chandra
Hi SKC,
I want it to run through macro not manually.
Thanks,
Chandra
Dear Chandra,
Pls See The macro I hope it gives u solution
...........................
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........................
Thanks,
Chandu