Post reply

Reporting Services, Mulit-Select Parms & Report Filters

  • October 8, 2009 at 2:08 am

    #1063269

    hello i'm a beginner at this but i think my question is related to this thread

    Problem:

    i'm trying to filter in my "group by" using multiple selections of a parameter called "Year"

    1) i added my report parameter and selected "Allow multiple values"

    [see attached screenshot]

    2) then in my series group properties i added a filter where the value was the report parameter above

    [see attached screenshot]

    Attempts:

    a) i have tried

    =split(Join(Parameters!Year.Value,","),",")

    and

    =split(Join(Parameters!Year.Label,","),",")

    and selecting IN instead of "=" in the operator field but i just get the error message "Value is not an integer number"

    b) if i use =Parameters!Year.Value(0)

    then the query runs but i obviously only get the first year from the (many) selection

    please help

  • October 11, 2009 at 7:17 am

    #1064518

    hello everyone.... i'm still stuck on this.... any ideas?

    sorry to bother you

  • October 21, 2010 at 8:09 am

    #1240341

    I am trying to use the "IN" clause filter on the Data Set as described in this post. As soon as I select "IN" the use of the function goes away. It is grayed out. I'm not sure why it is doing that but it is preventing me from using it. I am using the function to allow the filter to toggle between being used in the selection and not being used.

    Any advice?

    Thank you,

    Nathan

  • October 21, 2010 at 9:04 am

    #1240385

    What is the data type of "YEAR" from your demandVersusTemp dataset?

    Try this:

    Select your Year field from your dataset.

    "IN"

    [@year]

Viewing 4 posts - 16 through 18 (of 18 total)

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