Hi,
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 report...data will be dispayed and all the restricted nodes will be displayed as closed...and option to the user to expand.
Thanks