How to remove 'Select a Value' from the drop down list.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

amitmittal77 - 29 Dec 2005 12:41 GMT

I am using SQL Server 2005 RTM. In which i am getting 'Select a value' in all
the drop down list.
I don't want 'Select a value' in the drop down list
Please advise how to remove it from the drop down list

Reply to this Message

William - 29 Dec 2005 14:16 GMT

Your report has parameters and unless a default is provided you will get the
'Select a value message. If you want it to be blank, provide a blank as the
default value.

Reply to this Message

Jéjé - 29 Dec 2005 14:19 GMT

you have to provide a default value for your lists.
without a default value, the Select a value text is displayed

>I am using SQL Server 2005 RTM. In which i am getting 'Select a value' in
>all
> the drop down list.
> I don't want 'Select a value' in the drop down list
> Please advise how to remove it from the drop down list

Reply to this Message

amitmittal77 - 30 Dec 2005 05:06 GMT

I am using dataset for the dropdown which have default default values
the default value setting in the report parameter Screen is

i have selected From query option in default value section
under From query folllowing values have been selected
Dataset - my dataset
Value field - Parameter value

Still i am getting 'Select a value'

>you have to provide a default value for your lists.
>without a default value, the Select a value text is displayed
[quoted text clipped - 4 lines]
>> I don't want 'Select a value' in the drop down list
>> Please advise how to remove it from the drop down list

Reply to this Message