My requirement is, I have two prompts in my report Country and City. So now if I enter the country prompt then only it should ask the city prompt. AND if I enter the country equal to India then the next city prompt should show only India cities in the selected list.
I thought it possible in the universe level with cascading prompts, so please help me how to create cascading prompts or please tell me if you know any other way?
Hi Mark,
I tried in BO3.1 and when I ever click on Generate LOV’s the designer is kicked out.
Other way of creating cascading prompts by editing Objects has been done, but the values are not coming properly.
3. City
2. State
Country
When I choose 1. US 2.DE 3.City = Newark
in the output, I do get multiple states which has ‘Newark’ like example ‘CA’;‘DE’;
Why am I getting multiple values for single city, didn’t I create proper cascading prompt using objects?
That’s the way it works. Only the last item selected (city in your case) is actually added to the query conditions. In order to generate a correct result, you can either try setting up index awareness (so that the condition is based on city_id and not city name) or concatenated values (where the combination of state + city is used as a condition instead).
Hi Dave,
Thank you for the quick response.
If I am doing index awareness, how can I prompt the user with City Name.
As you suggested, I should do concatenation which will be messy in our LOV’s.
To add one more point, I am creating the cascading prompt on a Oracle view, which doesn’t have any Id’s.
If you don’t have any ID values available, then index awareness is not an option. The only remaining choice that I am currently aware of is to do concatenation. Since your final selection (city) is not unique, the behavior you describe is what you’re going to get.
With Crystal you can access the different prompt levels and add a condition on state and city separately. With Webi and Deski you only get access to the last selection (city).
Thanks for this help.
This create cascading lov is working fine for me (boxir2), its giving proper results.
So my question is, How to edit or delete the created cascading prompts?
Go to each object, double-click, go to the Properties tab, click the Edit option on the LOV, and edit the query to fit your needs. Usually it’s just removing a prompt in this case.