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
