Skip to Content
author's profile photo Former Member
Former Member

How to remove Hierarchy Triangle Icon in Report Designer

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2008 at 09:34 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2008 at 07:24 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.