Multi-conditional display help

[bioCam]

I am not able to control hide/show prompts depending on another prompt criteria entered.  Pehaps my example can explain better.

Location Prompt
- Country
- Branch

List, Bar or Both Prompt
- List
- Bar
- List/Bar

If Bar or List/Bar is selected then display the Bar-Location-Option Prompt.  If Country is selected then the prompt items are..
Bar-Location-Option
- USA
- England
- Canada

If Bar or List/Bar is selected then display the Bar-Location-Option Prompt.  If Branch is selected then display this prompt.
Bar-Location-Option
- Branch A
- Branch B
- Branch C


If List or List/Bar is selected, display the List-Option Prompt. 

List-Option
- By Year
- By Quarter

If Bar is selected, List-Option Prompt must be disabled.  If List is selected, then the Bar-Location-Prompt must be disabled.

Your suggestion and advise is much appreciated.

[bi4u2]

I would use 2 prompt pages.

Page One would be the 2 required prompts: Location and Report Type. Set both of these to Auto Submit = Yes. Each of these would be required and multi-select = No.

One the second Prompt Page, set up your other prompts: Bar Location, Branch Location and List Option. You will need to create 3 Boolean Variables that you will attach to Render Variables on these prompts.

[bioCam]

Is it possible to use 1 prompt page only? 

[bi4u2]

Yes, but then add a prompt button to 'Re-Prompt' so that the conditional prompts can render.

[bioCam]

Yes, thank you.  The re-prompt made it work.  I was trying to use auto-submit for both instances and the behaviour was wacky.  Switching one to re-prompt fixed it all.  Thank you.

[bioCam]

Hi bi4u2 .... On further testing, the prompts are not fully behaving as expected.  Not sure why.  THis is what I have done.  I have changed the prompts a bit.

(x) = default selected

Location Prompt --> multi-select NO, has a Reprompt button next to it
- Country
- Branch (x)
- Zone

Report Type Prompt --> multi-select NO, no default select, auto-submit
- Graph
- Tabular
- Both


Graph Prompt --> displayed if Graph or Both selected, multi-select YES
if Country selected..  if Branch selected..   if Zone selected..
- USA                         - Branch A                - Zone 1
- England (x)              - Branch B (x)           - Zone 2 (x)
- Canada                    - Branch C                - Zone 3

For this I have 1 block render variable to hide/display Graph Prompt if Graph or Both is selected and 3 render variables to control which prompts to show based on the Location Prompt irem selected.


Tabular 1 Prompt --> displayed if Tabular or Both selected, multi-select NO
- CrossTab
- List Box (x)

Tabular 2 Prompt --> displayed if Tabular or Both selected, multi-select NO
- By Revenue (x)
- By Quantity

For this I have 1 block render variable to hide/display both prompts if Tabular or Both is selected.

For the test ...

1) Run the report,  select Graph, the Graph Prompt displayed with Branch items (since this is default), I can select multi-branches.
2) Select Country and click Reprompt, the Country items displayed.
3) Select Tabular, both Tabular 1 & 2 Prompts displayed, I select CrossTab and By Quantity.
4) Select Both, the Graph and Tabular 1 & 2 Prompts displayed.

5) Run the report again, this time select Tabular.
6) The report render begins processing .... it did not display the Tabular 1 & 2 Prompts (It should display Tabular 1 & 2 Prompts)

7) Run the report again, select Graph, select Tabular next and all is good again.

Could you please help and advise what I should do to prevent Step 6 from starting the report render process?  Thank you.

[bi4u2]

How about:

Location Prompt - no auto-submit
Report Type - no auto-submit

Re-Prompt (sends values of Location Prompt and Report Type to the Render Variables)

Graph Prompt (display/hide based on Render variable) - no auto-submit
Tab 1 Prompt (display/hide based on Render variable) - no auto-submit
Tab 2 Prompt (display/hide based on Render variable) - no auto-submit

Run Report

[bioCam]

Thank you Bi4u2..

Yes, Location Prompt - no auto-submit, Report Type - no auto-submit --> works :)  Thank you.

(I was using Report Type auto-submit because another report has this and I was hoping to make my report consistent - my report has additional prompts ..Location Prompt, Graph Prompt are new.)

The Graph Prompt does not pick up the default selection after the next instance of Location Prompt item is selected and shows again at another next selection.

This is how I create the Graph Prompt ..

1)  Create Graph Prompt (Value Prompt), Parameter = p_Graph, add Static Choices 'USA', 'England', etc.  Default Selection = 'England'.  Render variable 'ShowGraph' if value=Country is selected.

2)  Create Graph Prompt (Value Prompt), Parameter = p_Graph, add Static Choices 'Branch A' etc.   Default Selection = 'Branch B'.  Render variable 'ShowGraph' if value=Branch is selected.

3)  Create the 3rd as similar to the above.  Render variable 'ShowGraph' if value=Zone is selected.

To test:
- Run report, select Country, click Reprompt -> Graph Prompt displays with England as default selected.
- Select Branch, click Reprompt -> Graph Prompt displays the branches with NO default selected.
- Select Zone, click Reprompt -> Graph Prompt displays the Zone 2 as default selected.

- Run report again, select Branch, click Reprompt -> Graph Prompt displays with Branch B as default selected.
- Select Zone, click Reprompt -> Graph Prompt displays the zones with NO default selected.
- ... it just toggles display default selected and NO default selected after every Location selection.

Do I need to create 3 separate parameters so it won't get mixed up?