My Pivot table width is not fitting in A4 Report size
Hi all,
I have created a Report using report tab. In my QV i have Pivot table which is to be used in report. but problem is pivot table has too many columns and too long in height it covers 3 A4 pages..my problem is width of the pivot table it doesn't fit in A4 size how to make it fit.
There is only so much information you can fit into a page. If your table is too big to print onto one page (whether it's due to the width or height), then you're going to have to make some compromise.
I believe your options are:
Allow it to print onto multiple pages (or any many pages as is needed)
Use Fill / Fill with aspect to squeeze the table onto one page, but you might not be able to read the text, unless you print it on an A3 paper
Reduce the number of columns (to reduce the width) and let the height be dynamic
Split the PivotTable into many smaller tables to make it more manageable for printing
hi shawn thanks for quick reply...i have tried fill/fill with aspect...do we have any other options...width is my problem and also i m not going to print as hardcopy.
