Lookup a Data Source to create Combo Box for user entry

To give you a feel, the parameterization syntax will support a new "lookup" type as follow:

${Company Name#lookup(Fruit,CompanyName)#B}

This will create a parameter on the UI with label Company Name with a combo box that reads its values from the datasource called Fruit using the field called "CompanyName". The default selection will be company B.

Further, the datasource "Fruit" can be either:
a) the name of a Data Source within a Report (ERD)
b) the name of a Graphic Object within a Composite Diagram (Ensemble)
c) the name of a View using view: syntax (Perspective)
d) the name of a datasource in the Repository (All)

Also, further parameters can be passed in if the datasource requires parameters:

${Company Name#lookup(Fruit,CompanyName,User=Peter,Password=Peter)#B}

This then forms the basis for incorporating Cascading support with:

${Company Name#lookup(Fruit,CompanyName,Country=${Country}#B}

You can allow look data source in the repository

${Company Name#lookup(repository:/Sales/Fruit.ds,CompanyName,Country=${Country}#B}

-- SooGuan - 22 Dec 2005