Dynamic dropdown list
Dynamic dropdown list
(OP)
Hi,
Environment: Developer Studio 5.2
I created a report which requires "Country", "Area", "Region", "Branch" parameters to work. These parameters are hierarically related.
I inserted this procedure in the "Resource Layout Painter".
Now, I made the values for those parameters to be displayed in the drop-down list box dynamically for the database.
Everything is fine until now.
All I want to do is the data in the second drop-down list should change depending upon the data on the first drop-down list.
i.e., when I select a country say "USA" from the first drop-down list, the 'Area' drop-down list should populate only those areas in "USA", and when I select a area say "SOUTH WEST" in the 'area' drop-down list, the 'region' drop-down list should populate with the areas in "SOUTH WEST" and so on...
I contacted the IBI people and they said that WF cannot handle it, and it should be implemented coding the HTML file that is generated by the "Resource Layout Painter". I think javascript is good for this. I have no idea how to proceed.
I can send the project file and the HTML file that I am working on if you mail me at webfocusraj@yahoo.com
Please help me.
Regards
WF RAJ
Environment: Developer Studio 5.2
I created a report which requires "Country", "Area", "Region", "Branch" parameters to work. These parameters are hierarically related.
I inserted this procedure in the "Resource Layout Painter".
Now, I made the values for those parameters to be displayed in the drop-down list box dynamically for the database.
Everything is fine until now.
All I want to do is the data in the second drop-down list should change depending upon the data on the first drop-down list.
i.e., when I select a country say "USA" from the first drop-down list, the 'Area' drop-down list should populate only those areas in "USA", and when I select a area say "SOUTH WEST" in the 'area' drop-down list, the 'region' drop-down list should populate with the areas in "SOUTH WEST" and so on...
I contacted the IBI people and they said that WF cannot handle it, and it should be implemented coding the HTML file that is generated by the "Resource Layout Painter". I think javascript is good for this. I have no idea how to proceed.
I can send the project file and the HTML file that I am working on if you mail me at webfocusraj@yahoo.com
Please help me.
Regards
WF RAJ
Talk To Other Members
RE: Dynamic dropdown list
simple example
<select name="COD" size="10" class="formfieldText" id="COD" style="width:70px"
onCHANGE="relatec(document.QueryForm, 'MEA', this,'')">
<option value="CCIC" >CCIC</option>
<option value="USA" >USA</option>
<option value="UK">UK</option>
<option value="AUS">Australia</option>
</select>
<select name="MEA" size="10" multiple class="formfieldText" id="MEA" style="width:300px">
</select>
here on selecting a country it will automatrically populate a measure for that country.will give the java script for this.