Diplay Prompt value base on other prompt selection

[a.chamkeri]

Hello everyone,

I have a report with 2 prompts on the prompt page:
Division and Currency.
Values for Division comes from query and Currency has static values ( MEX, USD, CAN).
Depending on the value selected in the Division prompt, I want to show only 2 values in the Currency prompt.

Ex: If i select Mexico as division, Currency prompt should show only MEX and USD.
      If i select Canada as division, Currency prompt should show only CAN and USD.

I guess this can be done wid Java script, if yes can anyone provide me that.


Thank,
Ajay

[rockytopmark]

1). Build 2 prompts for Currency.  The Mexico one would have only MEX and USD static selection entries, and the Canada one would have CAN and USD.
2). Create a Conditional Variable, call it v_Division_Sel ... of type Text and make its expression the Division Parameter, such as: paramValue('pDivision') and create 2 values of 'Mexico' and 'Canada'
3). Set each Currency Prompt's render variable to use v_Division_Sel and check the appropriate Variable value for the prompt
4). **Lastly, add a Reprompt button, that when clicked will force the Render Variable to refresh and select either Prompt to display.
** Optionally, set the Division prompt to auto-submit, so that you wouldn't need a button.  Just make sure the filter on Currency is Required, as is the Prompt Control

HTH

[a.chamkeri]

Hi,

Thanks, for the repy.
I tried ur suggestion and found the following things:
When i run the report, the prompt page displays 1 prompt (division), when i select the division the report runs and shows the data.
Now when i again run the report ( using the |> button ) it shows 2 prompts.

I have used auto submit for the 1st prompt.

I have attached the XML of the test report.

Thanks in advance