Default Text parameter to *SELECT ALL* - not showing

• RVO

  SSCertifiable

  Points: 5495

  More actions

  August 22, 2013 at 11:37 am

  #276400

  I default text Parameter to *SELECT ALL*

  but it's not showing at SSRS front end.

  Available Values: None

  Default Values: *SELECT ALL*

• RVO

  SSCertifiable

  Points: 5495

  More actions

  August 22, 2013 at 12:42 pm

  #1644078

  I found it.

  I just overwrote parameter on Report Server, in the parameters section

  But then I realized it's not good enough.

  What if the user searches for a keyword, runs the report and then wants to go back to <ALL DATA> mode?...

  He would need to type <SELECT ALL> again ? ....hmmmm

  Here is what worked for me.

  ----------------------------------------------------------

  On Report Server I set the parameter to:

  Has Default : check

  Default value : blank

  Null : check

  Prompt User: check

  In the stored procedure I default input parameter to NULL.

  -----------------------------------------------------------

  I still don't like NULL small check box at the front

  but this is the best I can do now.