I am trying to create a report that will pull the data based on a parameter. The parameter needs to me numeric and multi value.

Here is my sample sql statement:

select
sum(Rooms) as Rooms,
sum(Revenue) as Revenue,
Month(RoomDate) as Month,
Year(RoomDate) as Year

from
booking

where
bookingtypeid in (@BookingType)

group by
year(roomdate),month(roomdate)

I have @BookingType setup as a numeric multi value parameter on the report. However I cannot get the query to run. It states it is trying to convert the value to a string. Not sure how to do this. Users need to be able to select multiple booking type ids and then that feeds into the query.