Problem with <Select a value> in report parameters

Hot Topic

AND OR question
SQL Server 2005 incorrectly claims I don't meet minimum service pack level requirements?
left outer join produces cartesian product
SQL Server Express/Visual Studio Express, installation failure
SSMS scripting Stored Procedures to separate files
How do you return query results in a streaming table-valued function?
Unable to connect to SSAS
Unable to run "Management Studio(ssmsee.exe)" for Sql Express edition
Hide/Show parameter based on Multi-Valued Parameter Selection
SSRS 2005 XML datasource & report subscription question

SQL Server

Final Part - Min() Function
Help with IIf statement in expression
Active Directory Groups Authenticate
Emailing from Reporting Services 2005
Error: Unable to load one or more of the requested types.
identity_insert in SQL 2005
Script generation for Objects - Management Studio
Problem using SQL Server Mobile 2005 with Windows Mobile 5 application
how to run the Service Broker Samples
SQL Server 2005 SP1 installation hangs at authentication verification

Problem with <Select a value> in report parameters

Hello, Everyone

please, could you make clear how can I avoid appearence of <select a value> in drop downs at all.

thanks




Answer this question

Problem with <Select a value> in report parameters

  • !Jonathan

    steveareno wrote:
    not sure if this will work, but could you set a default value of a zero length string or null value

    It will definately work if you automatically select the first (or any) item in the list.

    sluggy

  • Atkins

    not sure if this will work, but could you set a default value of a zero length string or null value

  • A. Argueta

    but doesn't work =)

    I have a next drop down with predefined values:

    Show all = -2
    Local = 0
    Another one = -1

    I make default value = -2
    and when I open report via browser I get this drop down with prepopulated values and currently chosen is Show all

    BUT also I can choose <select a value>

    P.S. I afraid that I should write custom code for UI of Reporting Services

    Thanks, lads



  • Problem with <Select a value> in report parameters
Answer this question