Hi,
I am using Report Studio 10.1 and want to know if we can show / hide a prompt based on number of values returned for selection.
E.g. I have 3 prompts defined (cascading)
1. Product Brand
2. Product Color (Cascade Source: Product Brand)
3. Product Name (Cascade Source: Product Color)
I want to show the Product Color prompt only if the number of values returned are more than 1. If one value is available for selection, I want to hide the prompt.
Please let me know if this can be done.
Thanks in Advance.