Hi All,
I have got a cascaded prompt in a report which goes like this.
The user first selects the Territory and the corresponding Accounts in the territory. The cascading is working fine but when i try to display the Territory in the report it is showing two territories which is also correct because the Account can be aligned to two territories at a given time.
Now my requirement is i need to show only that territory which is selected in the cascaded prompt during the run time. When I pull the object selected in the query panel it is displaying two territories which i do not want. I just want to show the territory that is selected by the user.
Let me know if you have any questions.
chetan.mudike 
(BOB member since 2008-02-13)