on 09-19-2007 11:33 PM
I assigned a hierarchy to 0GL_ACCOUNT and restrict on certain nodes just below the root.
How do I prevent these nodes from being expanded in query?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can set Hiearchy Properties either in Query Level or Hierarchy Maintenance Screen.
You need to enable check box for Expand Level to '1'.
Assign points if it helps.
Nagesh Ganisetti.
go to properties of the IO in the query and uncheck expand hierarchy check box - default is 3
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.