Multi-Value Paramters in SSRS
Posted on 2010-11-15
I'm having an annoying problem here..
My query looks like " where Month(ADM_Date) in (@MONTH)"
The Param @Month type is Integer - setup to allow multiple values!
when I pass 1 or 2 indvidually , it works fine...
when I pass 1, 2 ,3 ,4 etc... it fails " error: The Value provided for the report paramter 'Month' is not valid for its type"
when I change its type to TEXT, of course I get an error !