Filtered data in Drop Down list

[Former Member]

Hi All,

I am doing a VC application. I am using BI query as Data source. I have two Drop Down list in input form. Both list gets filled up dynamically. Second list contains lots of data because of which application gets lot of time to load. I want second list should contain data which is relevant to value selected in first drop down list. For e.g.

Suppose first Drop Down contains available departments in an organization then I want Name of employees in that department only in second drop down, not name of all employees from the organization.

Is there any way to send data back to BI query when I select value in first drop down before submitting the input form?

I am using VC7.0 NW 2004s SPS11.

I will assign points to correct solution.

cheers

Jayant

[Former Member · Accepted solution]

Hi,

I would use a small workaround: make two input form with each one drop down list. Create a RFC or a small query, which take the department and returns the employees. Send the department to the new data service, which fills the second drop down list.

Then you create somewhere a submit button, which sends both information to the original query, which you use now.

Regards

Matthias

[Former Member]

I assume you have two drop-downs and if the user selects one drop-down the list in the second drop down should change dynamically.

To achieve this:

1.Configure the Output port for the first Drop-Down

2.Configure the <b>Input port(This is key) </b> and Output port for the second drop-down.

3. Now under the Input Port of second Drop-down open the formula builder , drag and drop the first Drop-Down.

This should work as you desired.

[Former Member]

Hi Jayant,

I think this WIKI entry should helps you:

<a href="https://wiki.sdn.sap.com/wiki/display/VC/LinkingDrop-DownLists">https://wiki.sdn.sap.com/wiki/display/VC/LinkingDrop-DownLists</a>

Best Regards,

Marcel