on 08-24-2012 8:45 AM
Hi all!
I've got in one of my queries 0ORGUNIT which has hierarchies. Customer asked me to display this char by default with the level 2 of the hierarchy, is it possible?
I know there's an option in Query Designer "Expand to Level", but I'm not sure what is this for, if this is the maximum levels report can display, or the default level I need.
Can you advise please?
Cheers!
best way is to try it out :-), but that displays up to levels not tat the level means it will display 2 levels.. if you want it to display that particular level FLAT only ,i dont think bw queries have the option yet to do that , you wil have to do some type of coding in cmod.. there is a way around i found on Report it self.
right click on the item that has the hierarchy
go to its property
go to its hierarchy tab, click expansion level 1, as that will give you the .1 level or if u need 2 position the lower node ABOVE and check bos condesntion of lower level nodes. that will SHOW you the top node in the report while hiding the other nodes underneath it..
try that and good luck
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.