Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Unanswered: Report Parameters in Reporting Services

    Hi guys & gals

    I'm just setting up Reporting Services for our company and it's a great product, no doubt about it. However, I've come across a problem I can't solve and I wonder if any of you can help.

    I've produced a sales report and I want my users to be able to enter a list of sales periods to include on the report. For example, the user might want to view the report for periods 10,11,13,14 and 17 and exclude periods 12,15 and 16. Obviously, the underlying query will probably involve an IN() clause but I'm struggling to think of a way that the user might be able to enter these parameters.

    The most obvious way might be by typing in a comma separated string, but I don't know how to then put those values into the query.

    Anyone got any ideas?

  2. #2
    Join Date
    Nov 2004
    Use a muli-select parameter, then use the IN clause against your parameter.

    Here is an example.

    Dataset - select salesperiod from sales where
    salesperiod IN (@periods)

    Report Parameter - Add parameter periods (use multi-select)
    use from query for defaults.

    preview report from drop down select the periods you want.

Posting Permissions

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