how to create a cascade prompts using the checkbox. There are a total of 3 checkbox prompts i want to use in my scenario, for ex:
Region State DEALER
USA OHIO 111
222
NEW YORK 333
444
555
CANADA CALAGARY 666
777
So for the above scenario if we select USA then it should display only the corresponding states and if we select the state it should display the corresponding Dealers associated in that state.
These are should be in the checkbox prompt and we should not be using REPROMPT condition and the user should also have the ability to do a select all on all three filters.
I am not really sure if i am clear enough with the Logic i have mentioned but any suggestions are of a great help to me...
That's a very specific requirement.
Auto-cascade only works with single-select prompts (checkbox is multiselect, its single select option is radio buttons).
There's my method for automatic multiselect cascade here (http://www.ibm.com/developerworks/library/ba-pp-reporting-scripting_techniques-page673/index.html (http://www.ibm.com/developerworks/library/ba-pp-reporting-scripting_techniques-page673/index.html)), but it is written for listbox prompts. Modifying it to work with checkbox prompts will take a bit of coding.
I think your options are limited to the classic two when dealing with a very specific requirement: either to change the requirement or to develop the solution. In your case, you can either:
1. Use a reprompt button; or:
2. Change to listbox and use my solution; or:
3. write a solution for checkbox prompts.
Hi Nimrod,
I am having some problems with getting the code in the link that you have sent, so can you help with the download of the Report Sepc. Also is there a way we can use the script for the checkbox option and have multi select values and change the values accordingly in the cascading prompt values...
Thanks for your reply
Quote from: v2k4u on 14 May 2014 10:58:09 AM
Hi Nimrod,
I am having some problems with getting the code in the link that you have sent, so can you help with the download of the Report Sepc.
I can try to help with specific problems, but I am unqualified to solve "some problems", nor can I offer help with downloading a file when I don't know what the issue downloading it is.
Quote from: v2k4u on 14 May 2014 10:58:09 AM
Also is there a way we can use the script for the checkbox option and have multi select values and change the values accordingly in the cascading prompt values...
I actually answered that already:
Quote from: Nimrod Avissar on 14 May 2014 01:43:06 AM
There's my method for automatic multiselect cascade[...]but it is written for listbox prompts. Modifying it to work with checkbox prompts will take a bit of coding.
To clarify further, the answer to your question is yes, the solution can be modified to cater for checkbox prompts. It will require some coding by someone who is fluent with Cognos prompt handling.