Skip to Content
avatar image
Former Member

Filtered data in Drop Down list

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    May 21, 2007 at 07:25 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 21, 2007 at 07:18 AM

    Hi Jayant,

    I think this WIKI entry should helps you:

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

    Best Regards,

    Marcel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 22, 2007 at 04:36 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded