Print Page - Tree Prompt Levels

Title: Tree Prompt Levels
Post by: abu_a on 03 Nov 2008 04:23:32 AM

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

Title: Re: Tree Prompt Levels
Post by: kado on 12 May 2009 05:33:41 PM

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!!!

Title: Re: Tree Prompt Levels
Post by: kado on 12 May 2009 05:46:56 PM

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.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: abu_a on 03 Nov 2008 04:23:32 AM