Cascading Prompts ??

[kado]

Hello!

I've got 2 prompts. The master prompt is defaulted to a certain value and the cascading prompt is waiting for this value to set its values. The query for the cascading prompt will be filtered down appropriately but nothing will be selected.

Does anyone know how I can set this value of the cascading prompt so it is actually selected and submitted?

thanks,
Kado

[LimeInDaCoconut]

The master prompt :
1) Auto-Submit : Yes
2) Cascade source : <empty>
3) Default Selection : The value that should be default. (i.e. "Shoes")

The detail prompt :
1) Auto-Submit : No
2) Cascade source : Master prompt
3) Default selection : The value that should be default (i.e. "red")

[kado]

Thanks for the reply.

Within the 2nd prompt I can't set a default selection because it will always be different. It will always be just 1 value and will change based on who is running the report (I'm trying to resolve a security issue).

Anyway to have it passed and selected without setting a default value in the 2nd prompt (the prompt receiving the cascading value)?

Thanks again!