I have 2 queries in my report . the firts query has name, addrees, state,city and i have no prompts in this query(1). I am having a second query where i have a prompt for state and a second prompt for city. If i select a state for the first prompt (ie state) i should get a list of all cities as selection list for my second prompt where the user can select the value from this list. Please let me know how to achive this in business objects.
good4ru (BOB member since 2005-08-03)
THis can be achived in Universe.
When you give the Where clause for the City object.
Something like,
with 2 alias tables
Select City
From Location1.City
Where
Location1.State=Location2.State And
Location.City=@Prompt('Select City',c,,)I am not strong in SQL but just to give a lead i tried.
KhoushikTTT 
(BOB member since 2005-02-24)
I am not sure but you might be looking for what is known as “cascading prompts”. Please, look at this Designer FAQ: How do I create cascading or nested prompts?
Andreas 
(BOB member since 2002-06-20)
We can do, need to create a temporary state(temp_state) object in designer with a prompt for the country, I mean in where condition we need include a condition as below…
Location.Country = @Prompt(‘Select Country’,‘A’,‘Address/Country’,‘Mono’,)
then the second condition you can create as designer object or in report level, it should be as
Location.State = @Prompt(‘Select State’,‘A’,‘Address/temp_state’,‘Mono’,)
we must select the new temp_state object for the second condition’s lov…
Have a nice weekend
vamsigoud (BOB member since 2005-09-17)
Using SDK for showing the list of values might be an option too. (Might not be ideal but).
Regards.
Nithya (BOB member since 2005-09-07)