Printing PDF

Wed, 18 Aug 2010 08:28:08 GMT

I have looked through the forum and I am close to a resolution on this but I cannot quite get the code right for what I want to do.

I want to be able to run a report for each possible selection in this case company name and name it as the company name.

What I am getting is one file not split by company, but when I run the test in the module I see the selection box flick through all the possible selections.

The code I am using is. The outcome I want is the report run once for each company possible value.

Thanks

Sub pdfprint
UrlPath = "c:\pdftest"
set val=ActiveDocument.Fields("Company_Name").GetPossibleValues
for f=0 to 0

reportName01 = f
reportFile = UrlPath & val.Item(f).Text & ".pdf"
HOLA= PrintReportPDF( "RP01", reportFile)
ActiveDocument.GetApplication.Sleep 5000
next
End Sub
'___________________________________________________________________________________________________________________________________________'
Function PrintReportPDF(oReport, pdfOutputFile)
Set WSHShell = CreateObject("WScript.Shell")
WSHShell.RegWrite "HKCU\Software\QlikViewPDF\OutputFile", pdfOutputFile, "REG_SZ"
WSHShell.RegWrite "HKCU\Software\QlikViewPDF\BypassSaveAs", "1", "REG_SZ"
ActiveDocument.PrintReport oReport, "QlikViewPDF", false
set WSHShell = nothing
End Function

topic Printing PDF in QlikView

Printing PDF