Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
Hi
You can achieve this using NPrinting. You can even email those reports to various users as well.
Ragards
Harish
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.
Thanks Harish,
But i don have NPrinting...
Hi Frank,
This is exactly what i need.. please send me the syntax for me to try ..
thanks...
have a look at attached txt file
hope this helps!
Thanks Frank.
I will check and revert.
Regards,
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.
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.
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!