Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys is there a way to compress the whole pivot table at once?
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
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
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.