Using Tree Prompt

[sydazak]

Hi All,

I create a hierarchy table in FM and created a tree prompt on my report (Report Studio). my levels are something like this

-A
--AA
--AB
--AC
-B
--BA
--BB
--BC

Where A is a parent and AA,AB,AC are the child.. now the problem is i have 10 levels all together.

my issue is when a user selects level 'A' for example the report which is a list report should section by the next level which in this case would be..
the list would break down by AA,AB and AC.


Any ideas on how to do this.. thanks much appreciated

[charon]

Hi Sydazak,

are you using an DMR Model?

You might wanne try sth like using a Data Item with a prompt macro for the rows.
The prompt macro holds the parameter which will be filled with the dimensional reference from the tree prompt. Using the dim. value you build sth. like "children()", a dimensional function (look it up in the report studio dimensional function list". autosend property on the tree prompt... and this might do the trick. Didnt try it on myself though..just an idea :)
good luck :P
cheerz charon

[sydazak]

Yes i am using a DMR for the prompt only because i need a tree prompt and thats only possible if the underlying table is in layers.

And BTW every solution was an idea at first :) thanks will give it a try and let you know