Post reply

can't select many values in filter

  • June 1, 2014 at 12:55 am

    #286031

    hi all

    i did a parameter and its coresponding filter of shop in a report then when i put just one value in filter it shows data to me but when i choose many it gives me this message error

    and i can't put many values in the shop filter in one time i should put value by value 🙁

    this snapshot shows how i enter values

    thanks a lot for any help

  • June 1, 2014 at 3:16 pm

    #1718088

    I assume this parameter is used somewhere else?

    If you use it in a query, make sure the query can handle it.

    SQL Server Reporting Services Using Multi-value Parameters[/url]

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 3, 2014 at 1:30 am

    #1718434

    Probably you have a problem with the filter in Dataset. You have to use "In" instead "=".

  • June 4, 2014 at 9:06 am

    #1718873

    Yep, you need to check your query:

    WHERE

    .

    .

    AND (Shop.ShopAddressID IN (@ShopID)

    .

    .

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply