<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Reporting Services
»
Reporting Services
»
Remove 'select a Value' from drop down of...
13 posts, Page 1 of 2
1
2
»»
Remove 'select a Value' from drop down of report manager
Rate Topic
Display Mode
Topic Options
Author
Message
Arunkumar S P
Arunkumar S P
Posted Monday, April 06, 2009 8:27 AM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, May 09, 2012 10:59 PM
Points: 230,
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
Post Attachments
Parameter label.JPG
(
74 views,
79.57 KB
)
Post #691062
Luke L
Luke L
Posted Monday, April 06, 2009 11:43 AM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:42 AM
Points: 2,891,
Visits: 5,858
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
Post #691300
Arunkumar S P
Arunkumar S P
Posted Tuesday, April 07, 2009 4:18 AM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, May 09, 2012 10:59 PM
Points: 230,
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
Post #691814
Luke L
Luke L
Posted Tuesday, April 07, 2009 6:29 AM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:42 AM
Points: 2,891,
Visits: 5,858
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
Post #691904
Arunkumar S P
Arunkumar S P
Posted Tuesday, April 07, 2009 7:09 AM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, May 09, 2012 10:59 PM
Points: 230,
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
Post #691956
Dave Klug
Dave Klug
Posted Wednesday, April 08, 2009 4:06 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:00 AM
Points: 1,049,
Visits: 1,119
You could set up the parameter as multi-valued or with a default value in order to supress the text.
Post #692897
laurie_ruleman
laurie_ruleman
Posted Tuesday, May 19, 2009 8:58 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, May 20, 2009 11:11 AM
Points: 1,
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.
Post #719936
Arunkumar S P
Arunkumar S P
Posted Tuesday, May 19, 2009 9:03 AM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, May 09, 2012 10:59 PM
Points: 230,
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
Post #719945
Lewis Dowson
Lewis Dowson
Posted Thursday, April 01, 2010 5:31 AM
SSC Rookie
Group: General Forum Members
Last Login: Wednesday, August 31, 2011 7:47 AM
Points: 30,
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
Post #894619
jkoon-760461
jkoon-760461
Posted Monday, May 24, 2010 3:39 PM
Right there with Babe
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 10:14 PM
Points: 784,
Visits: 357
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.
Post #927112
« Prev Topic
|
Next Topic »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
