Hi all,
I am working on hierarchical data which has up to 6 levels and these hierarchies are coming along with the transaction data itself. So there is no separate master for it.
My data set I am trying to load is:
User Dept L1 Dept L2 Dept L3 Dept L4 Dept L5 Dept L6.
I would like to show the department list as hierarchies with the expandable '+'/'-' icons.
I have tried to concatenate the 6 level column as Dept L1/Dept L2/Dept L3/Dept L4/Dept L5/Dept L6 and then in the list box used the separator to show as hierarchy.
The selections work fine for the lowest level where I can select it but when I try to select an higher level which has multiple child levels, the selection does not work.
Any advice on how I can get that to work.
thanks,
Amit.
