Results 1 to 3 of 3

Thread: SSRS parameter select all help

  1. #1
    Join Date
    Jun 2008
    Posts
    10

    SSRS parameter select all help

    Please can someone provide an overview of how to select all records in the parameter list. I am trying to get an understanding of how this works.

    Having a union join with all value is fine, to retrieve the value of 'all'. However, given the data-set there is no 'all' value. From reading the ms course notes, the query syntax is: select from where = (field = @x) or @x = 'all'. How does this syntax work? Does x = all, so all= all = true then returns all records?

    Regards,

    Nijojo

  2. #2
    Join Date
    Aug 2007
    Posts
    4
    Use a multi-value parameter and change the query in your dataset from '= @parameter' to 'IN (@parameter)'.
    If you need to select all by default, use the same query used to generate available values in the default value query.
    Hope that helps.
    Ninj :-)

  3. #3
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    Did This One Do It For You?

    Did the above answer work for you? Please advise if you hit further obstacles ...

    Good Luck,

    Bill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •