Compress wholz pivot table at once

[#1]

Hi guys is there a way to compress the whole pivot table at once?

[Miguel_Angel_Baeyens]

Hi,

First go to the chart properties, Presentation tab and make sure that "Always Fully Expanded" is unchecked. Then right click on the first dimension [+] sign and select "Collapse All". That should do.

Hope that helps.

Miguel

[#3]

i mean when i am viewing the report, is there a way to implement a button which has that function? without having to go to properties

[Miguel_Angel_Baeyens]

Hi,

Check the APIGuide.qvw file for the class ITableProperties. I guess there's a way to do it via macro, although I don't recommend to do that way should there is some API to do it.

Regards.

Miguel

EDIT: John Witherspoon wisely explained here how he achieved something like that without using macros. I think it's worth taking a look.