Optional Cascading Prompt

Hello Everyone,

I have a hierarchy with center/Sector

In our report we have a center as required prompt and Sector as an optional prompt. Only When the user wants to select a specific ‘sector’ which is an optional prompt I would like to pass the userresponse of ‘Center’ value, so that he is only prompted for those sectors corresponding to the selected Center.

If I define a Cascading prompt on Sector,Center will be prompted again,but the user doesn’t want to reenter the center to select a specific sector.Please let me know if it’s possible to achieve…

Thank You


vdasari (BOB member since 2009-10-21)