In this tutorial video, we build a separate prompt page in Report Studio using multiple cascading prompts. We examine the adjustment and settings of properties associated with cascading prompts needed to allow these prompts to function efficiently and properly. Specifically, we review the multi-select-auto-submit, and static choices properties. In addition, we show the use of a complex ‘if’ statement used in a detail filter used to populate a ‘static choice’ field in a prompt.
Check out our YouTube channel for many more Cognos tutorial/tips & tricks videos.