RRDI Report: cascaded multi-select control
Hello all!
I'm looking for a way to add cascaded multi-select control on the prompt page in Report Studio. I used on prompt page two report parameters for user choice: RTC Project Areas to narrow down the list of Areas of interest, and Iterations belonging to them to select from. The use case should look like this: the user selects Project Areas he wants to select iterations from in the first control and then in the second control he selects specific iterations from those Areas while seeing which Iteration belongs to which Area. ProjectArea -----> Iteration PrjArea1 -------> I1.1 I1.2 PrjArea2 --------> I2.1 --------> I2.2 Any ideas on implementing this? |
3 answers
To do this you first need to create two queries:
- - On your prompt page you can then create two value prompts with one bound to each of the above queries. On the project value prompt you need to set the auto-submit property to true, and on the iteration value prompt you need to set the cascade source to the project prompt. You can then set the iteration value prompt to multi-select, then in your main queries you can use the filter syntax in (?Iterations?) Hello all! |
|
Oops, I know. But it's not really what I would like. I want to select multiple Projects Areas but for multiple choise the auto-submit property have value only false. So I would like to have ability to construct as tree-hierarchy structure, i.e. multiple choise for Projects Areas and specific iterations from those Areas while seeing which Iteration belongs to which Area
|
Yes, this is a known limitation and people have to click Reprompt. A
colleague of mine found this whitepaper, which I have not tried myself, but it sounds promising (requires a little bit more work, though): http://www.ibm.com/developerworks/data/library/cognos/reporting/advanced_report_design/page583.html Peter. On 5/2/2012 12:38 AM, irinav wrote: Oops, I know. But it's not really what I would like. I want to select |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.