cancel
Showing results for 
Search instead for 
Did you mean: 

How to remove Hierarchy Triangle Icon in Report Designer

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Samay,

I am sorry but that was the only solution I can think of. Might have to do some research.

Regards

Abhijit N.