Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Print pdf pages in different files

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

7 Replies
edu_oliveira
Partner - Contributor III
Partner - Contributor III

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

Not applicable
Author

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!

Anonymous
Not applicable
Author

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)

Not applicable
Author

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

Anonymous
Not applicable
Author

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...

Anonymous
Not applicable
Author

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


Not applicable
Author

thanks a lot!!!! ill try it!