dynamically save various reports as pdf with different filename

[#1]

Dear All,

I am trying to automatically save various reports as pdf.  Reports should have different file name.  May i kindly ask how to do it in qlikview.

I appreciate your help.

Regards,

[#2]

can't open the qv file.  license for my qv will be available anytime soon.

Frank, i am using 'report' designer available in qlikview, so i don't need to export anything in powerpoint.

I have this code (in macro)

ActiveDocument.Fields("Company").select "Name of Company"

ActiveDocument.Fields("Year").Select "XXXX"   // where XXXX is the year

ActiveDocument.PrintReport "RP01", "PDFCreator"

ActiveDocument.Fields("Company").select "Name of Company1"

ActiveDocument.Fields("Year").Select "XXXX"   // where XXXX is the year

ActiveDocument.PrintReport "RP01", "PDFCreator"

ActiveDocument.Fields("Company").select "Name of Company2"

ActiveDocument.Fields("Year").Select "XXXX"   // where XXXX is the year

ActiveDocument.PrintReport "RP01", "PDFCreator"

ActiveDocument.Fields("Company").select "Name of Company3"

ActiveDocument.Fields("Year").Select "XXXX"   // where XXXX is the year

ActiveDocument.PrintReport "RP01", "PDFCreator"

and so on and sor forth.

[harishkumarg]

Hi

You can achieve this using NPrinting. You can even email those reports to various users as well.

Ragards

Harish

[Frank_Hartmann]

i am not familia with report designer.

but if the following video is what you want to achieve i will help you setting up the qvw.

[#5]

Thanks Harish,

But i don have NPrinting...

[#6]

Hi Frank,

This is exactly what i need.. please send me the syntax for me to try ..

thanks...

[Frank_Hartmann]

have a look at attached txt file

hope this helps!

[#8]

Thanks Frank.

I will check and revert.

Regards,

[#9]

Hi Frank,

Please advise the part of the  syntax where it's auto save, i am thinking of using only that part in my pdf creator.

[#10]

I have several objects that needs to be exported.  If you could help me the steps on how to start a template in ppt putting in mind that several objects in one slides is required. 

[Frank_Hartmann]

For preparing the template you will just have to copy the charts and paste them into the powerpoint template.

then just make sure that if your first Qlikview Chart has e.g. the ObjectID = Chart  then you have to name the image in

Powerpoint = Document\Chart and if your second Qlikview Chart has the ObjectID = newChart  then you have to name

this image in Powerpoint= Document\newChart

See attached video for instructions.

hope this helps!