Step 1:

 

This feature will provide you the capability to create your own pick within VisualRep without writing any line of code.

VisualRep will store the pick list definitions in its own data dictionary. It is all data driven.  

 

Select the below option named: Selecting value from pick list to enable the picklist tab.

 

Figure A:

 

 

Step 2:

 

Click the Pick List tab. The figure B below is shown up.

 

Figure B:

Pick List options:

 

No.	Options	Description
1	Value Header	The primary key header description for the pick list column.
2	Description header	The actual description header column.
3	Value	The value for the primary key for the pick list selection. If you have a Building name Larking then the Value for that building could be: Lar
4	Description	The building name is the description as Larkin, Keating Hall etc..
5	Include the Value Header column in picklist.	That is an option whether you want to see the 2 columns in the pick list or just the description column only.
6	New	Add new record.
7	Remove	Remove current highlighted record.
8	Undo	Undo last change.
9	OK	Will save all parameter’s info.

 

Step 3:

 

Enter the value needed for your lookup. When this parameter is selected in the query parameter the

list entered below will show in the parameters form. You can add as many records as needed.

 

Figure C:

 

Step 4:

Select the parameter into the query filter and all is automated for you. When you run the report or query the

below is combo box is filled with the list created above.

Figure D: