I have a report that has a search and select prompt to find an account number.
Additionally I have a date prompt for a start and end date to find the transactions for an account number between those date ranges.
This is the scenario I on how I go through the prompt page:
1) Select the start and end date I wish to look for
2) Search for a account (example 12345)
3) The prompt page refreshes with the account 12345 being a value selectable in the search and select prompt
4) The stand and end dates are reset to the default which is today's date
Is there any way I can have the date prompts retain their values while a search and select prompt is being used?
The only time I have seen this is when I was using JavaScript to set the default value of a date prompt. When the page refreshes (from the REPROMPT action -- fired from an autosubmit) my JavaScript routine would reset the date prompt to the default value. It's possible that loading the Search & Select prompt performs a REPROMPT.
How is the default value for your date prompt set?