I have a report (BO 6.5) in which the possible LOV displayed for one prompt depends on the answer provided by the user to another prompt. Is it possible to do any or all of the following:
Use universe/BO/VBA to control the possible values that appear in the LOV for a given prompt depending on the answer to a previous prompt?
Control the order in which the user answers the prompts in order to ensure that the correct LOV is displayed for each prompt?
For example, say the user was to first select a country and then select a city in that country. I want the user to first select the country wihout being able to select any city and, once a country is selected, I only want cities in that country to appear in the LOV for the city prompt. Any help would be appreciated.
You can do this by cascading or nested prompts
But it will be one prompt for eg country and within it you can have another prompt to pass city, in this way you will have only those countries for the city selected.
For more details look into Designer FAQ for cascading prompts