In my report I am showing data in Pivot Table, most in collapsable format. Can i perform any action on button click to expand all the collapsed rows in one go.
Is there anyway to achieve this.
Thanks Boris for your reply.
Yes, I can do that but in that case then collapse option doesn't appear on the screen.
Anyways there is another way to achieve this, user accessing the report via web can always right click on the column and say expand / collapse.
View solution in original post
You can keep your pivot table Always Fully Expanded by checking this box in chart properties --> Presentation tab. Otherwise, users should expand/collapse manually.
Hope this helps.