How to set your own ssrs default parameter

• SqlServerNinja

  Ten Centuries

  Points: 1238

  More actions

  December 2, 2013 at 2:00 pm

  #279568

  I am using a SSRS Parameter for my reports.

  The parameter is populated by a Dataset - sql query.

  select ProductName from Product

  I set these values using the 'Available Values' option

  I want to set the Default Values as "Select"

  When I select the No Default Value , the output message I see is is * select a value"

  But my requirement is to see only "Select"

  How is it possible ?