on 06-13-2008 9:17 PM
Hello,
I have created one report in Report designer based on one query in which we have GL Account hierarchy.
Hierachy is expanded till 4 levels by default and user is NOT going to expand any nodes further. But he do not want the triangle icon in that hierarchy. Can any one tell me how to remove them?
I know in Workbook we have this option but in Report Designer, how can I do this? Or if not in report designer, do we have any setting in Query Designer so that I disable this icons while creating query itself. That would also do.
Thanks in advance!!!
Samay
This is what comes to mind if I think of a solution.
If you do not want the Hierarchy Icon.You can hard code the query.
Create a structure --> New selection-> and select one node of Hierarchy. then again select a New Selection selct next node on Hierarchy.
Basically creating a strcuture in which each new selection will represent each node of your Hierarchy would solve your problem.
This will definitley remove your triangle icons. If you have any problems implemnting this solution let me know.
Hope this helps.
Regards
~Abhijit N.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Abhijit for the reply. Problem with this approach is that I have to hardcode hudreads of nodes as we have a huge hierachy. This would definitely be a lot of overhead.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.