I am building a report using SSSR and have a parameter in my query that accept integers.
for example the where statment is currently where customervalue in (@CValue)
in the parameters on the report I have a list 0 thru 10 where user can select as many numbers as they want to pull the list back.
I want to have just 3 categories though
Low = 0,1,2,3
Medium = 4,5,6,7,
High = 8,9,10
But if I put in the available values for paremeters - Low and then in value 0,1,2,3 i get the error "Conversion failed when converting the nvarchar value '0,1,2,3' to data type in.
Is there anyway I can do this or do I have to have 0 - 10 as the options ?