Remove 'select a Value' from drop down of report manager

Question

Remove 'select a Value' from drop down of report manager

Arunkumar S P

SSCertifiable

Points: 6415
More actions
April 6, 2009 at 8:27 am

#202527

Hi experts,
Is it possible to remove 'select a Value' from dropdown in report manager?.
I set the default value for parameter from query
I attached the screen shot of my parameter settings. kindly look in to that picture and give me a solution
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.
Thanks,
Arunkumar S P

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Luke L SSC-Dedicated Points: 35547 More actions · Answer 1

Not sure what's going on with your instance, but I just set up a parameter exactly as you have it and I am not getting the select a value entry. What version of SSRS are you running I'm at SSRS 2005 build 4035. Also are you writing this via Visual Studio or Bids, and are you seeing this behavior in your Preview tab or from the SSRS web site itself? I've noticed some differences between the 2.

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

Arunkumar S P SSCertifiable Points: 6415 More actions · Answer 2

I'm using SSRS 2005 but i don't know how to check build number?. Please guide me

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P

Luke L SSC-Dedicated Points: 35547 More actions · Answer 3

Not really sure if there's an easier way to get that info, but if you go to your drive:/Program Files/Ms SQL Server/MSSQL directory/Reporting Services/Logfiles and open the most recently created log file, near the top there will be a element which will display the Reporting Services Version. Currently mine is 9.00.4035 (RTM + SP3 if I remember correctly.)

Also, you didn't specify if you were seeing this behavior on the server or in your preview tab of your development environment, nor did you describe which IDE you were using. Are you using a full blown Visual Studio instance or the cut down BIDS (Business Intelligence Development Studio) version that ships with SQL Server?

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

Arunkumar S P SSCertifiable Points: 6415 More actions · Answer 4

Thanks Luke

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P

Dave Klug SSCertifiable Points: 5811 More actions · Answer 5

You could set up the parameter as multi-valued or with a default value in order to supress the text.

laurie_ruleman Valued Member Points: 73 More actions · Answer 6

This problem has been bothering me for sometime and I find it hard to believe that no one on any forum has figured out how to get rid of this Microsoft "feature". Setting a default value for the dropdown box DOES NOT remove the "Select a Value" option from the dropdown values. This is being added somewhere behind the scenes for some unknown reason. Part of confusion is that this does not happen when you look at the drop down in the Preview of the IDE. You only see it after you deploy the report to the server. Does anyone have a solution? I would be greatly appreciative.

Arunkumar S P SSCertifiable Points: 6415 More actions · Answer 7

Yes laurie_ruleman. I'm also searching for this answer for a every long time. please some one help

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P

Lewis Dowson SSC Eights! Points: 988 More actions · Answer 8

-------------- SOLUTION -----------------------------------

After playing around with this I now have the solution for you.

In the parameter:

Go to default values

Select Specific Values

Enter the Value(not the label)

i.e.

id name

1 UK

2 USA

3 Spain

You need to enter 1 in the Specific Value, not UK.

This will default the drop down to

id 1

name UK

jkoon-760461 Ten Centuries Points: 1109 More actions · Answer 9

So far no one has the solution. I have tried all suggestions and while they appear to work while in the IDE, as soon as the report is uploaded to the Report Manager website, the <Select a Value> is back. It is very annoying.

Dag H. Baardsen Grasshopper Points: 17 More actions · Answer 10

It seems like, when the source query of the parameter returns a NULL value or you specify that NULL values should be okay to input, then you get the "<Select a value>" dropdown.

I did a source query like this, including a NULL row to use as a default parameter:

SELECT Id, Name FROM MyTable

UNION

SELECT NULL, "<All values>"

When I used this in Report Builder I got the rows I wanted. However, switching to Report Manager, I always got a "<Select a value>" as an additional, default row.

What I did to resolve this, was changing the query to:

SELECT Id, Name FROM MyTable

UNION

SELECT -1, "<All values>"

and instead of specifying the NULL value as default in the parameter's property, I replaced the default value with -1. Voilá - the "<Select a value>" disappeared and my "<All values>" entry showed up.

FEREYDOON ESMAEILI Grasshopper Points: 21 More actions · Answer 11

I have applied all suggestions from this frum and many others. They are mostly the same and no one worked form me. The problem is it works fine in IDE, but not in Report Manager.

Nullified SSC Journeyman Points: 87 More actions · Answer 12

In the Report Manager click by the side of the report to bring on the other options. Click on Manage. In the report properties, click on Parameters. Set the default value for what ever parameter you were doing in the BIDS. VOILA...

I faced the same issue. Tried this method and got it.

Cheers!!!

Vihar