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?
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:
-Project Prompt which has the project ID and name as data items
-Iteration Prompt which has the iteration ID and name as data items. Additionally you need to add a filter on . = ?Project?
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?)
-
-
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!
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?
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:
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
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