1. Code for the plain HTML parameter form

<form name="form1" method="post" action="">
    <h2>Parameter Form</h2>
    <p>Choose a department from the list, then click the <b>Run Report</b> button
    to show salary details for each employee in that department.</p>
    <select name="p_department" size="1">
      <option value="1">a</option>
    </select>
    <br>
    <input type="text" name="userid" value="hr/hr@db-connect">
	<br>
    <input type="submit" name="Submit" value="Run Report">
</form>

2. SQL Query for the Data Model

select department_name, department_id
from departments
order by department_name

3. Dynamic LOV element in Web Source View


<select name=" p_department">
<rw:foreach id="fn" src="G_department_name"> 
<option value="<rw:field id="f_deptId" src="department_id"/>"><rw:field id="deptname1" src="department_name"/></option>
</rw:foreach> 
</select>