topic Re: dynamically save various reports as pdf with different filename in QlikView

dynamically save various reports as pdf with different filename

Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: dynamically save various reports as pdf with different filename

marcus_sommer — Fri, 30 Sep 2016 08:40:03 GMT

You could use a specialized tool like QlikView NPrinting or something like this: Print Report to PDF with open source PDFCreator.

- Marcus

Re: dynamically save various reports as pdf with different filename

Frank_Hartmann — Fri, 30 Sep 2016 12:36:46 GMT

You could also use a vbs-macro in order to export your charts/tables into one or more predefined PP-Templates.

Inside the vbs-code you could also make the filename of the PP-Template dynamically e.g. adding a timestamp or other logic to the filename and determine where to save the reports. If this is something that fits your needs then let me know for further assistance.

Re: dynamically save various reports as pdf with different filename

Sun, 02 Oct 2016 13:32:26 GMT

Thanks Marcus / Franc for your reply.

Below is the sample of the code:

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

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

ActiveDocument.PrintReport "RP01", "PDFCreator"

I have 20 or more listed company and i need to print each company's financial for several years, let say from 1990's to present. where report for each year and each company is required.

What i need is the syntax to auto save the report and save it with different filename automatically.

Regards,

Re: dynamically save various reports as pdf with different filename

marcus_sommer — Tue, 04 Oct 2016 07:11:29 GMT

You need to loop through your field. Here is an example for exporting objects to excel - but the logic is the same like your printing-task.

- Marcus

Re: dynamically save various reports as pdf with different filename

Tue, 04 Oct 2016 07:18:12 GMT

Hi Marcus,

Thanks. Please send an example. looping is fine but what i cannot understand is how to save it with different filename (automatically)

Regards

Re: dynamically save various reports as pdf with different filename

Tue, 04 Oct 2016 11:07:33 GMT

Dear Frank,

Thanks...Please share sample codes as it fits my requirements..

Re: dynamically save various reports as pdf with different filename

Frank_Hartmann — Tue, 04 Oct 2016 14:08:36 GMT

Hi Roberto,

I have attached an example for exporting/creating multiple PP-reports dynamically!

You will just have to adapt the paths inside the vba code in order to get it work in your environment!

This macro loops through every sheet of you qlikview document and exports the relevant charts -->

(for setting up the PPTemplate you will have to copy the relevant chart (e.g. CH01) once into the PP Template and name the object like this: Document\CH01). The macro also loops through the fields "company" and "year" and it creates a new Report everytime when the one loop is finished.

hope this gives you an idea on how to get started!

Frank

Re: dynamically save various reports as pdf with different filename

Frank_Hartmann — Tue, 04 Oct 2016 16:08:34 GMT

are you on personal edition?

Re: dynamically save various reports as pdf with different filename

Wed, 05 Oct 2016 06:11:39 GMT

Thanks Frank. I will check the zip file and get back to you.

Yes, i am currently using the personal edition.

Re: dynamically save various reports as pdf with different filename

Wed, 05 Oct 2016 06:17:27 GMT

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.

Re: dynamically save various reports as pdf with different filename

harishkumarg — Wed, 05 Oct 2016 06:28:11 GMT

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

Ragards

Harish

Re: dynamically save various reports as pdf with different filename

Frank_Hartmann — Wed, 05 Oct 2016 15:52:32 GMT

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.

Re: dynamically save various reports as pdf with different filename

Thu, 06 Oct 2016 06:53:00 GMT

Thanks Harish,

But i don have NPrinting...

Re: dynamically save various reports as pdf with different filename

Thu, 06 Oct 2016 06:54:59 GMT

Hi Frank,

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

thanks...

Re: dynamically save various reports as pdf with different filename

Frank_Hartmann — Fri, 07 Oct 2016 09:55:20 GMT

have a look at attached txt file

hope this helps!

Re: dynamically save various reports as pdf with different filename

Sun, 09 Oct 2016 11:19:25 GMT

Thanks Frank.

I will check and revert.

Regards,

Re: dynamically save various reports as pdf with different filename

Tue, 11 Oct 2016 06:14:55 GMT

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.

Re: dynamically save various reports as pdf with different filename

Tue, 11 Oct 2016 06:16:49 GMT

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.

Re: dynamically save various reports as pdf with different filename

Frank_Hartmann — Tue, 11 Oct 2016 19:21:43 GMT

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!