Two Prompts

[system]

Hi All,

There are two prompts for my report. one for “Region” and other for “city”. In this “Region” there are 4 sub Regions like East, West, South,Midwest. Each Region having different Cities.

…
Region- East West South Midwest
Cities- Boston Los Angeles Dallas Chicago
NewYork San Francisco Miami Colorado springs
…

So, According to my report if i have selected west region in first prompt then the second prompt(city) should show only belongs to west(i.e., Los Angeles,San Francisco)
Similarly, if i have selected south region in first prompt then second prompt(city) should show only belongs to south(i.e., Dallas,Miami).

Thanks in Advance.

---

santhosh.tl (BOB member since 2006-09-18)

[system]

Hi,

You can use Cascade prompts.

Cheers!!!
Swamy

---

bvrswamy (BOB member since 2006-06-18)

[system]

Please, see this Designer FAQ on How do I create cascading or nested prompts?

---

Andreas (BOB member since 2002-06-20)