Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic dropdown list

Status
Not open for further replies.

webfocusraj

Programmer
Aug 24, 2003
14
US
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
 
I have dynamic picklist working fien for country region area and district , i use java script just giving some light on this ...


simple example


<select name=&quot;COD&quot; size=&quot;10&quot; class=&quot;formfieldText&quot; id=&quot;COD&quot; style=&quot;width:70px&quot;
onCHANGE=&quot;relatec(document.QueryForm, 'MEA', this,'')&quot;>
<option value=&quot;CCIC&quot; >CCIC</option>
<option value=&quot;USA&quot; >USA</option>
<option value=&quot;UK&quot;>UK</option>
<option value=&quot;AUS&quot;>Australia</option>
</select>


<select name=&quot;MEA&quot; size=&quot;10&quot; multiple class=&quot;formfieldText&quot; id=&quot;MEA&quot; style=&quot;width:300px&quot;>
</select>


here on selecting a country it will automatrically populate a measure for that country.will give the java script for this.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top