I have many columns in my pivot ,how to print all the data of pivot table with repeated header,i can see all the data in print but problem is if i set “fit” property to “page” column data gets shrinked(too small),in another way if i set fit to data pivot table gets print in column wise format,got splitted columnwise during print.In this case row Dimension of pivot table is not repeated for all pages.Is there any way enable to show row Dimension in all pages.?
what should be exact solution to resolve this? can anyone please guide me.