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.
I did not understand your issue. How many hierarchies you are using?
As per my understanding for eg, if you have given the level upto 3 then in the selection screen of the report , you will have the option to select upto 3 levels. So, if you make it upto level 0, then how can you select the level upto 7?
Could you please elaborate