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