Hi All, I have 2 prompts in a report.Requirement is, based on the value entered in 1st prompt the 2nd prompt LOV should appear. For ex the 2 Prompts are
Country
States
Based on the Country what you are entering in the Country prompt, only the corresponding states should display in the LOV of 2nd prompt
I tried like giving same prompt statement of Country to Country object and in the LOV query of States.Problem is the prompts are coming twice in the webi while running the report. Prompt given in Country object is coming as usual but LOv prompt is coming under the States prompt.
Users dont want the Prompt twice, is there anyother way i can achieve the same