Dynamic Positioning of Pivot tables

[#1]

Hi All,

I have 7 Pivot tables one below the other on my Report.

Each report is having drilled data.

Now if I expand 2nd dimension to see the drilled data, it will increase the height of the Pivot table also overlapping on the Pivot table below it.

Can we do something so that when we expand 2nd Dimension on 1st Pivot table, 2nd Pivot table and all below it also moves down?

[#2]

Hello All,

I did resolve the issue of not allowing the objects to overlap on expansion by

unchecking the option of 'Size to Data' on Layout tab of the Pivot table.

[Anonymous]

Hi Arvind,

I'm also facing same issue. But i didn't find the Size to data Option. Can you tell me where that option will appear in Nprinting Report?

Thanks And Regards

M Subash

[Anonymous]

First unchecked the Size to Data from Options In 'Layout Tab' then you have to size it manually.