How to export multiple sheet objects in single pdf?

[#1]

Hi Experts,

Can you please guide me if there is any way or workaround to export multiple sheet objects into single pdf file?

Thanks in advance.

[bbi_mba_76]

Hi,

maybe you could use this post to export all in an excel common Macro to export excel for 6 different objects and then you have to export the excel as pdf

[#3]

Thanks Michele.. I will try to implement this and let you know the results.

[Colin-Albert]

You could add the objects to a report and then print the report to pdf.

[#5]

Hi you can create a report and then print the report in a macro.

regards,

MT

[Colin-Albert]

You do not need a macro to print a report - you can use an action for this.

[#7]

I know that you dont need a macro but in my case I had to save the pdf automatically into a specific folder and this you cant do with an action.

regards,

MT

[#8]

Hi Colin,

Thanks for the solution.

I tried to add the objects to the report, but on a single page I can accomodate 3-4 objects only.

I need to loop the report for different customers. So, if I go on adding new pages then first the objects on first page will get repeated after that all the objects on second page will start lopping by customers.

Is there any way to accomodate all the objects( I need to add approximtely 10 objects) on a single page?

Thanks in advance

[Colin-Albert]

You can set the report so either the whole report can loop through each value in a field, or you can set a page to loop through the values. ]

Look at the Report Settings - Banding and Page Settings - Banding

[Clever_Anjos · Accepted solution]

Use a report

Two helpful Reading

1) http://community.qlik.com/blogs/qlikviewdesignblog/2013/09/06/using-qlikview-s-report-editor

2) http://community.qlik.com/docs/DOC-4709