Adding a Multilist Parameter

The following example shows how to display a multilist field on the Report Parameters page:
Figure 1. Defining a parameter for a multilist field
<PARAMETER>
  <DISPLAYNAME>Device Status</DISPLAYNAME>
  <BINDNAME>status</BINDNAME>
  <TYPE>MULTILIST</TYPE>
  <DBLOOKUP>(select Status code,11 
    Status description from devicestatus ) 
    union (select '||||', ' All Device Status' 
    description ) Order by 
    description</DBLOOKUP>
</PARAMETER>
  1. Database lookup query that returns status descriptions from the devicestatus table.