Actually i am having a sheet which contain 20 pivot reports, i want that when i click on Print button all 20 reports get print out one by one.
I am able to do that by using "Print Sheet" Action but in this all pivot reports are coming with scroll bar means if in a single report having 24 column but visible only 12 in a pivot report with scroll bar. so at the time of print it come as same as in sheet mean with 12 column & scroll & i want all 24 column.
Is there any option to remove this scroll while using macro or some thing else.
There is an excellent tool called NPrinting which is now endorsed by QlikTech. This enables you to scheudle the production of QlikView charts, tables and reports and have them sent automatically to folders, mulitple email addresses, or webspace in Excel, Word, HTML , PowerPoint or PDF formats.
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
