SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Arunkumar S P
Arunkumar S P
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1567 Visits: 870
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


Attachments
Parameter label.JPG (103 views, 79.00 KB)
Luke L
Luke L
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8445 Visits: 6139
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

For better help with performance problems please read this
Arunkumar S P
Arunkumar S P
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1567 Visits: 870
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
Luke L
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8445 Visits: 6139
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

For better help with performance problems please read this
Arunkumar S P
Arunkumar S P
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1567 Visits: 870
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
Dave Klug
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2159 Visits: 1174
You could set up the parameter as multi-valued or with a default value in order to supress the text.
laurie_ruleman
laurie_ruleman
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 1
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
Arunkumar S P
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1567 Visits: 870
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
Lewis Dowson
SSC-Enthusiastic
SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)

Group: General Forum Members
Points: 194 Visits: 154
-------------- 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
jkoon-760461
SSC Eights!
SSC Eights! (845 reputation)SSC Eights! (845 reputation)SSC Eights! (845 reputation)SSC Eights! (845 reputation)SSC Eights! (845 reputation)SSC Eights! (845 reputation)SSC Eights! (845 reputation)SSC Eights! (845 reputation)

Group: General Forum Members
Points: 845 Visits: 360
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search