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

  • 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

  • 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]

  • 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

  • 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]

  • Thanks Luke

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

    Thanks,
    Arunkumar S P

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

  • 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.

  • 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

  • -------------- 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

  • 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.

  • 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.

  • 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.

  • 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

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

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