I need a sistem to create diferent reports files automatic in pdf. When i make the print report all of them are created in a single pdf and i really need to save them in different files to send them to my sellers. Is there any macro or sistem to do this??? i have qlikview 8.5
thanks!
Hola,
Necesito un sistema para crear un reporte en pdf en distintos archivos, la idea es enviar a cada vendedor lo que le corresponde solo a el. Esto debería ser automatico ya que son cerca de 90. Solo e logrado generar un pdf con todos los reportes junto, lo que no me sirve. existe alguna macro o sistema para hacer esto?
I already did that, the probles is that its create only a single pdf, and i need that every page of the report (posible value) its created in a different pdf file, i need to do this becaus there is some prived information for every seller.
To create a separate file, you have, instead of using banding, use a loop in the macro wich selects values one-by-one and prints the report. (I had do do it in the older days wehn banding didn't exist)
But im creating the reports whithout a macro, im only sending the by clicking report and in the print option i select print to pdf. I tried whith the macros in this forum but i coudnt work any of those. What macro i should use? thanks
This is working macro which picks values within selection one-by-one and creates PDF files. I'm using PDF-Xchange 3.0 here, it is installed by QlikViewPDF To make printing silent, without user confirmation, I had to configure printer "Save"properties - do not show "save as" dialog, provide path and file name, and "When file exists" set to 'auto number'. Here is the macro:
sub Print set f = ActiveDocument.Fields("Field") set sel = f.GetSelectedValues for i = 0 to sel.Count-1 f.Select sel.Item(i).text ActiveDocument.GetApplication.WaitForIdle ActiveDocument.PrintDocReport "RP01", "PDF-XChange 3.0" next f.SelectValues sel 'restore selections end sub
