Skip to Content
author's profile photo Former Member
Former Member

Passing drop down box values to web item "table" to filter table contents

Hi,

I am trying to pass "drop down box" values to table. this is what i am doing.

i want the report not to be executed before making selections out of dropdown box.

I've 2 data providers one for dropdown box(DATAPROVIDER_1) and one for table (DATAPROVIDER_2).

DATAPROVIDER_2 is empty without any query.

based on the drop down box selection, I am resetting the DATAPROVIDER_2 to DATAPROVIDER_1 and also trying to pass drop down values to table.

I could able to reset the DATAPROVIDER_2 but i am not having any luck to pass the drop down selected values.

after i select a value from drop down box, data provider (DATAPROVIDER_2) is being reset and all the values are being displayed in the table but i want only records of those drop down selected value.

I appreciate if you can help me. here is the code.

<HTML>

<!-- BW data source object tags -->

<object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="SET_DATA_PROVIDER"/>

<param name="NAME" value="DATAPROVIDER_2"/>

<param name="DATA_PROVIDER_ID" value=""/>

DATA_PROVIDER: DATAPROVIDER_2

</object>

<object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="SET_DATA_PROVIDER"/>

<param name="NAME" value="DATAPROVIDER_1"/>

<param name="QUERY" value="Q3"/>

<param name="INFOCUBE" value="IC2"/>

DATA_PROVIDER: DATAPROVIDER_1

</object>

<object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="SET_PROPERTIES"/>

<param name="TEMPLATE_ID" value="VARIABLE_DROPDOWN_1"/>

TEMPLATE PROPERTIES

</object>

<HEAD>

<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">

<TITLE>BW Web Application</TITLE>

<link href= "/sap/bw/Mime/BEx/StyleSheets/BWReports.css" type="text/css" rel="stylesheet"/>

<script language="JavaScript">

function setVariable(a){

url = "<SAP_BW_URL>"+ "&DATA_PROVIDER=DATAPROVIDER_2&CMD=RESET_DATA_PROVIDER&INFOCUBE=IC2&QUERY=Q3&FILTER_IOBJNM=ZHIER01&FILTER_VALUE=" ;

url = url + a;

SAPBWOpenURL(url);

}

</script>

</HEAD>

<body>

<P>

<b> CustHier :</b> <select name="ZHIER01" class="SAPBexDdI" onchange="setVariable(options[selectedIndex].value);" size="1">

<object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="GET_ITEM"/>

<param name="NAME" value="DROPDOWNBOX_1"/>

<param name="ITEM_CLASS" value="CL_RSR_WWW_ITEM_FILTER_DDOWN"/>

<param name="DATA_PROVIDER" value="DATAPROVIDER_1"/>

<param name="GENERATE_CAPTION" value=""/>

<param name="IOBJNM" value="ZHIER01"/>

<param name="MAXVALUES" value="1000"/>

<param name="SHOW_LABEL" value=""/>

<param name="ONLY_VALUES" value="X"/>

<param name="NO_REMOVE_FILTER" value="X"/>

ITEM: DROPDOWNBOX_1

</object>

</select>

</P><object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="GET_ITEM"/>

<param name="NAME" value="TABLE_1"/>

<param name="ITEM_CLASS" value="CL_RSR_WWW_ITEM_GRID"/>

<param name="DATA_PROVIDER" value="DATAPROVIDER_2"/>

ITEM: TABLE_1

</object>

<P></P>

</body>

</HTML>

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Apr 13, 2004 at 11:11 AM

    Is this BSP you are using? (In that case I'll move your message to the right forum...)

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.