Multiple Cascading Prompts including multiple selections

[teresa.danna@gmail.com]

Hi all,

I'm a bit stuck. I'd like to do multiple cascading prompts which can only be done by using a reprompt button, which I've set up as such.

Basically the user selects the reports they would like to pull based on the Parm_Report prompt and then clicks the "Reprompt" button to get the cascading prompts based on the defined static collection.

Static Choices (Required, Multi Select, Check Box group, no auto submit (can't select auto submit on multi prompt):

Report A
Report B
Report C
Report D
Report E

Within each parameter filter on the prompt page I've used the string Variable with expression: ParamValue('Parm_Report') which has A,B,C,D,E as variables

With the following filters which are only applicable to:

Filter 1 (Parm_1) - Render for A,B,D - Calendar, Range
Filter 2 (Parm_2) - Render for B,C,D - Based on query, required (w/default set)
Filter 3 (Parm_3) - Render for B,C,E - Based on query, required (w/default set)

The problem:

If someone clicks on only one selection everything works fine, the other requisite prompts show up. But if they click on A,B and C or anything more then 1 static selection they get nothing.

I tried creating multiple similar prompts with only one variable set. IE: Parm_1 for A, Parm_1 for B, Parm_1 for D etc but that didn't work either. 

Any thoughts?

Thanks all for looking into it!
Teresa

[MFGF]

Hi all,

I'm a bit stuck. I'd like to do multiple cascading prompts which can only be done by using a reprompt button, which I've set up as such.

Basically the user selects the reports they would like to pull based on the Parm_Report prompt and then clicks the "Reprompt" button to get the cascading prompts based on the defined static collection.

Static Choices (Required, Multi Select, Check Box group, no auto submit (can't select auto submit on multi prompt):

Report A
Report B
Report C
Report D
Report E

Within each parameter filter on the prompt page I've used the string Variable with expression: ParamValue('Parm_Report') which has A,B,C,D,E as variables

With the following filters which are only applicable to:

Filter 1 (Parm_1) - Render for A,B,D - Calendar, Range
Filter 2 (Parm_2) - Render for B,C,D - Based on query, required (w/default set)
Filter 3 (Parm_3) - Render for B,C,E - Based on query, required (w/default set)

The problem:

If someone clicks on only one selection everything works fine, the other requisite prompts show up. But if they click on A,B and C or anything more then 1 static selection they get nothing.

I tried creating multiple similar prompts with only one variable set. IE: Parm_1 for A, Parm_1 for B, Parm_1 for D etc but that didn't work either. 

Any thoughts?

Thanks all for looking into it!
Teresa

Hi Teresa,

I'm officially befuddled :) You are referring to "parameter filter on the prompt page". Can you explain what you mean by this? A detail filter? If so, in what query - the query of a prompt or the query of your list/crosstab/chart etc?

Can you explain in simple terms a slightly senile muppet can comprehend? :)

Cheers!

MF.

[teresa.danna@gmail.com]

No problem! :) And BTW, I'm learning so much just by reading the posts....

The user does the selection using the checkbox group associated with Parm_Report (Parameter in table properties of prompt) on a page with initially one prompt (the others are hidden based on render variable). It uses a static selection, which relates to a variable to determine which reports the user would like to pull up. This variable also relates to additional prompts on the prompt page which should only show up if the initial filter says they want that report after they hit the reprompt button. I know, this is confusing....

Hopefully this example will help:

Variables:
var_Report (string) - A,B,C - ParamValue('Parm_Report')

***Prompt Page***

Prompt 1 - Parm_Report, static selection, default not set
  Selection A
  Selection B
  Selection C

<<<Reprompt Button>>>

Prompt 2 - Parm_Time, Calendar, Render Variable: var_Report: A,B

Prompt 3 - Parm_FY, Data - Query, Render Variable: var_Report B,C

***

This issue is, if on the prompt page the user selects that they want Reports A, they select repromp, they will get Prompt 2
However, if the user clicks on A & B, they don't get any of the filters for A & B. What I would like is that they then get Prompts 2 & 3.

Thank you!

[Lynn]

I suspect the issue is with your variable. The string values will be set as you expect when the user selects just one of the choices, but there are no possibilities for the various combinations of multiples, so nothing renders.

I prefer Boolean variables:

var_RenderPrompt2: ParamValue('Parm_Report') contains ('A') or ParamValue('Parm_Report') contains ('B')
var_RenderPrompt3: ParamValue('Parm_Report') contains ('B') or ParamValue('Parm_Report') contains ('C')

Then use each as the render variable for the corresponding prompt and set to render for true. Not sure I got that syntax exactly right but hopefully it provides an option to consider. Put a layout calculation on the second prompt page to show the paramValue contents...might help you debug your current string variable approach or a revised approach using Boolean.

And I agree that there is so much to learn from reading posts on this site!! Some very smart and helpful people hang around here!!

[teresa.danna@gmail.com]

That worked perfectly! It also solved an issue I was having with the reports themselves not coming up which I hadn't tested yet. I can't wait to use this in other reports.

Thanks much!

Teresa

[Lynn]

Yay!! Glad it worked out!!