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.
Why do you want to avoid making a Report? It seems that this would neatly solve all your problems, and make your life easier at the same time (you wouldn't have to click "Print" a million times because you can set up the report to cycle).
If you create a report that contains your too-wide pivot table, the columns that are cut off will be pushed to another page. You can set the report to be in landscape mode, which will help a bit. You can also play with page margins. But in general, the best approach would be to create a pivot that fits on a single landscape page of a report so viewers of the report will have a nicer experience.
Let's start with some definitions--what are you defining as a "Report" when you say you have 1,400 of them? I suspect we're talking about 2 different things. Do you mean 1,400 unique reports or 1,400 of the same report wtih different data?
If it is necessary to print to PDF, I think using Reports is a better choice, as Vlad recommends. If PDF is not absolutely necessary, I'd rather copy to Excel, using separate Excel sheet for each report. In the case of Excel you need macro with system access, that means it's not going to work with AJAX client.
Hi i think ther i third party tool name .NPRINTING TOOL
with the help of this tool u can connect to the server where ur file is mounted . once u access it that will open and it will give the format which u choose..
I don't think you actually have 1,400 unique pivot tables. I suspect you mean that you have a few pivot tables, but different combinations of data require that it be outputted 1,400 times as different PDFs. If that's the case, take a look at Reports >> Edit Reports >> Add >> Reports menu >> Report Settings >> Selections >> Banding. That will output a version of the report for each value in a field. If you have multiple reports and multiple fields that need to be looped, you can create a concatenated field in the script and loop over this field. If I am misunderstanding, please let me know.
