Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Remove 'select a Value' from drop down of report manager Expand / Collapse
Author
Message
Posted Monday, April 6, 2009 8:27 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 10:59 PM
Points: 229, 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 (80 views, 79.57 KB)
Post #691062
Posted Monday, April 6, 2009 11:43 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:05 AM
Points: 2,897, Visits: 5,981
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
Posted Tuesday, April 7, 2009 4:18 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 10:59 PM
Points: 229, 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
Posted Tuesday, April 7, 2009 6:29 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:05 AM
Points: 2,897, Visits: 5,981
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
Posted Tuesday, April 7, 2009 7:09 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 10:59 PM
Points: 229, 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
Posted Wednesday, April 8, 2009 4:06 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 4:21 AM
Points: 1,074, Visits: 1,153
You could set up the parameter as multi-valued or with a default value in order to supress the text.
Post #692897
Posted Tuesday, May 19, 2009 8:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, May 19, 2009 9:03 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 10:59 PM
Points: 229, 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
Posted Thursday, April 1, 2010 5:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Monday, May 24, 2010 3:39 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, October 7, 2013 3:17 PM
Points: 786, Visits: 359
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 »

Add to briefcase 12»»

Permissions Expand / Collapse