Skip to Content
Former Member
Jun 04, 2009 at 09:31 AM

Setting in Query Designer to close all the levels in hierarchy



I got a hierarchy with upto 8 Levels.

In Query Designer i had a Selection Restrictions on hierarchy,I selected few nodes (each will have upto 7 level).

When i execute the report the first node is expanding upto the Level 7 and other nodes are stay close...

I checked and tried all the setting Expand to level 0....etc

Its not working.

How can i achive

When the user executes the will be dispayed and all the restricted nodes will be displayed as closed...and option to the user to expand.