I have a parameter that displays a drop down list of values that the user can select from. The parameter displays the description, but the sql table is keyed by a code value, that I don't want to show the user, I though about building an arrary of code values in the custom code, but since I can't reference a data set inside the custom code, what would be the best way to build an array or is there a better way of showing the description but hide the code value from the user. thanks Dan1104Daniel J. Plocica

When you create your dropdown list you can set a value and a label. The user would only see the label values in the dropdown. These can then be accessed from within the report body by using Parameters!ParameterName.Label. HTH!every day is a school day

Thanks, I don't know what the difference was betwen the value and label fileds. This should solve my problem. Daniel J. Plocica

I have a parameter that displays a drop down list of values that the user can select from. The parameter displays Code followed by description, but the requirement is, user should only see the description not the code. Values of LocationCode fields are: 1. (234) - USA Newark, NJ 2. (235) - USA Orlando, FL 3. (534) - USA Detroit, MI 4. (634) - USA Chicago, IL . . . . There are more than 2000 location codes. In parameter drop down list user should only see "USA Newark, NJ" Is there any way i can achieve this? Thank you.

Please see the answer above from richbrownesq, using the value and label in the dropdown worked for what i needed to do. Dan1104Daniel J. Plocica