Skip to Content
0
Former Member
Jun 30, 2009 at 09:28 PM

How to suppress hierarchy levels on query visualization

33 Views

Hello Gurus, Does anybody know how to suppress from a level down on a query visualization?

I mean, if I have the following structure...

Level 1

Level 2

Level 2

Level 3

Level 3

Level 1

Level 2

Level 3

...I want users to be able to expand only until Level 2, not seing Level 3 down on and without displaying those arrows ">" at the left of Level 2 nodes.

If I set "Expand to Level" hierarchy property to "2" in query designer, the hierarchy is displayed correctly at the very first opening, but the users still have the arrow ">" sign at Level 2 and are able to expand the levels down on from there.

Tks in advance! Regards,

Marcelo Domingues.