Adding a Drop-Down List Parameter

The following example shows how to display a drop-down list field on the Report Parameters page. The list is populated from the database.
Figure 1. Defining a drop-down list parameter
<PARAMETER>
  <DISPLAYNAME>Called Type</DISPLAYNAME>
  <BINDNAME>CalledType</BINDNAME> 1
  <TYPE>DROPLIST</TYPE>
  <DBLOOKUP>select SiteID as code, 
  SiteName as description from sites</DBLOOKUP> 2
</PARAMETER>
  1. CalledType is the name of the parameter in the RPT file.

  2. Description will be displayed in the list. Code is the corresponding value for the parameter.