Cascading Value in Combo Box

[system]

Is there any way we can show cascading values in Combo Box (same feature as Filter Component)? Just say I have two combo box with country and state. If I select Country from the first combo box all state names should displayed in Combo box 2. Any idea?

---

Philip (BOB member since 2006-03-02)

[system]

How to implement Cascading filter dashboard??

I need to implement cascading filter in dashboard using Crystal Xcelsius… I have the req like this: A-- ALL A1 –A2 – A3 B – ALL B1 –B2 –B3 –B4 When you select A and select ALL from corresponding second filter, then it should return all the values in A not B values. rollings007 (BOB member since 2007-02-15)

Cascading combo box

So you have two combo boxes. They take their labels, respectively, from A1:A10 and B1:B10 So A1 = Automotive A2 = Trucks A3 = Rail etc. Now, prepare a table of combo boxes: in C1:E10, prepare the second combo box for each value. So C1:C10 are the labels for ‘automotive’: C1 = UK C2 = France C3 = Italy D1:D10 are the labels for ‘Trucks’: D1 = USA D2 = Canada etc. And E1:E10 are the labels for 'Rail Now, build the 2nd combo box. Assuming the 1st combo box inserts its chosen label…

---

ww55d (BOB member since 2011-06-14)

[system]

Yes ofcourse philip,

Bring in your State and City togather (QAAWS, BI Service whatever). Your first combo box bind the labels to State (have your states sorted), select Filtered Rows, your source data bind to both columns, give plenty of space of your destination binding. Then on your second combo box, bind your label to the City destination of your first combo box, make your insertion type label, and make your behvior Dynamic. And you should be good.

---

katullus (BOB member since 2009-08-21)

[system]

Thank you. It works.

---

Philip (BOB member since 2006-03-02)