how to create a cascade prompts using the checkbox

[v2k4u]

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...

[navissar]

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), 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.

[v2k4u]

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

[navissar]

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.

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:

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.