Tree Prompt Levels

[abu_a]

Hi All,

I have a tree prompt for Region. E.g. All --> Americas --> Canada

When I run the report the tree prompt loads at its highest level 'All'. I've tried using the 'Pre-populate levels' function in the properties window to change the level to a lower level e.g. 'Americas'. No matter what I change the value to, the tree prompt opens at the highest level. Does anyone know how I could get the tree prompt to open at a lower level i.e. 'Americas'

Thanks
Abu

[kado]

Did you ever figure out how to do this? I am faced with a similar issue ... I thought using the children() function would work but unfortunately not.

thanks!!!

[kado]

I got it .... add an additional item to your Tree Prompt query to represent the level you want to start at ... then on your prompt page update the 'Use Value' in your Tree Prompt to reference this new item.

Cheers.