Some questions on Cascading Prompts

[rcaesar]

Hi,

I am new to this forum, and new to C 8.4. I have a couple of questions on prompts, and am sure I can get some guidance here.

1) I have developed a set of prompts on a Prompt Page. I would like all of these to be in one page (I have done that), but the prompts don't display in the order I put them. For example, I created them in this order:
Status, Manager, Department. The results displayed, shows Department first. I've tried to move this around, but the results don change.

2) In the same prompts, I would like my users to display subsequent prompts when I make selections. That I do not want them to have to click "Re-Prompt" to get the filtered results in the next prompt. That is if I were to select 2 values in Status, then UPON selection, the next prompt should display the filtered values, and so on.

3) Lastly, I would like completely hide the Manager Prompt, and have it visible when I make selections on Status, and so on.

I know, I started off by asking questions, but I promise, I hope to also contribute as soon as I get my feet wet.

Thanks in advance

[cschnu]

Hi,

I am new to this forum, and new to C 8.4. I have a couple of questions on prompts, and am sure I can get some guidance here.

1) I have developed a set of prompts on a Prompt Page. I would like all of these to be in one page (I have done that), but the prompts don't display in the order I put them. For example, I created them in this order:
Status, Manager, Department. The results displayed, shows Department first. I've tried to move this around, but the results don change.

I'm assuming you used the wizard to create your prompt page there are a couple of properties of the prompts you need to look at cascade-source and auto-submit. The prompt you want first should not cascade off of anything, and then you just chain them together. So Manager cascades from Status and Department Cascades from Manager. Also, you need use auto-submit so that it filters your next prompt based on the cascaded prompt and your data. Also, if you don't not have these two parameters correct it may skip your prompt page and try to run your query. In that situation then it will ask you for the missing values in your where clauses of your query and this page can look similar to a prompt page. The difference is you will see this message
Provide values for the report you are about to run.
Indicates a required field.
Points to missing information.

2) In the same prompts, I would like my users to display subsequent prompts when I make selections. That I do not want them to have to click "Re-Prompt" to get the filtered results in the next prompt. That is if I were to select 2 values in Status, then UPON selection, the next prompt should display the filtered values, and so on.

cascade-source and auto-submit should solve this.

3) Lastly, I would like completely hide the Manager Prompt, and have it visible when I make selections on Status, and so on.

I know, I started off by asking questions, but I promise, I hope to also contribute as soon as I get my feet wet.

Thanks in advance

You will want to declare a render variable for the manager prompt widget on your prompt page. You then define the values of this render variable based on a report expression, which can include calculating based on another parameter variable in this case Status.

[rcaesar]

Much appreciated, cschnu.

I think your solution solves most of the issues. I have a question though:

It looks like I can select the auto submit property for the prompt, ONLY if I don't have the multi-select property to No. There ought to be a way where users can select multiple values in one prompt, and cascading into another based on those values (without the 'reprompt' button UI).
Thanks in advance.

[bloggerman]

Reprompt is the only solution

[Cynthia]

I have a problem similar to this... I have an auto-submit prompt with a cascading source.  However, when I chose a Display Value on the source of the cascade, it doesn't no auto-submit and reload the dependent prompt.

Does auto-submit not work with a Display Value as well?  When I just have the Use Value and no Display Value in the prompt, the auto-submit works fine.