Skip to Content
Sep 22, 2014 at 03:42 PM

How to make report with hierarchy static?



I thought that it will be simple task but I have already spent some time googling and experimenting and still no luck...

I need some of my reports be static - i.e. user can not use expand / collapse options on report.

I have set Lock option FormattingSheet and protected sheet - buttons greyed out.

Still I could expand by double click -> I have switched off "Enable double-click" in User options (although this does not suit me well because I need to block just some reports).

Now I see I still can expand from context menu...

Is there a simple way to freeze expand\collapse just for given report??