I have created a report in BIDS 2008 that connects via ODBC connection.
I am having issue with the parameters for multiple values.
In the Dataset query I have :
(M10.PARTNO in (:Alloy))
and in the dataset properites under parameter I have:
=join(Parameters!Alloy.Value, ", ")
This works if I select one value from the drop down, but if i select more than one it returns no data.
Can anyone please advise?