topic Print pdf pages in different files in QlikView

Print pdf pages in different files

Thu, 21 Oct 2010 15:46:16 GMT

Hi,

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?

saludos

Print pdf pages in different files

edu_oliveira — Thu, 21 Oct 2010 16:03:32 GMT

Hi Thomas...

See this help you.

Create a report, and in "Report Settings", in sheet "Selection" exists a options "Bandits- Loop Report over possibles values in field".

This option run a reports in a Loop for values to selected field.

Best regards

Print pdf pages in different files

Thu, 21 Oct 2010 16:15:11 GMT

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.

plese help!

Print pdf pages in different files

Anonymous — Thu, 21 Oct 2010 16:27:51 GMT

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)

Print pdf pages in different files

Thu, 21 Oct 2010 16:41:04 GMT

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

Print pdf pages in different files

Anonymous — Thu, 21 Oct 2010 18:17:11 GMT

Sorry don't old files, and don't have time now to create an example.
I'll get back when I have time, if nobody answers before...

Print pdf pages in different files

Anonymous — Fri, 22 Oct 2010 03:12:35 GMT

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

Print pdf pages in different files

Fri, 22 Oct 2010 18:42:11 GMT

thanks a lot!!!! ill try it!