OR filter for in with a parameter

• darth_vodka

  Default port

  Points: 1489

  More actions

  July 4, 2012 at 4:57 am

  #258836

  hullo

  i'm using SSRS 2008

  i'm trying to do a filter that says

  [FieldA] = list of values from a parameter

  OR

  [FieldB] = list of values from a parameter

  now...this isn't very easy is it?

  I can get a filter working for the AND

  and it seems the OR isn't an option, so my question boils down to a simpler one...

  how do I do a filter expression that looks like

  =Fields!Field1.Value In Parameters!param.Value

  but works?

  it doesn't like "In"

  and I assume I do it to return a boolean

• darth_vodka

  Default port

  Points: 1489

  More actions

  July 6, 2012 at 4:13 am

  #1509571

  i solved this by changing the dataset of the report, adding a WHERE clause in the SQL and putting the parameter in there

  where somefield in (@ParamList)

  sort of thing