I have a report based on a view. I have two parameters which work fine and filter my report. I have added a third. The data is on sql server 2005 and the field I want to filter is type numeric. My report is run from in asp.net from a web page. The user selects items in a list and a string is built and to be passed to the report. ie 106,2,02,284,354 In my report I have created a parameter called skill which I have set as string. I want my database field to basicly read
....where QId in ?skill
this works
{vweShowAnswers.STF_Community} like "*"&{?Community}&"*" and
{vweShowAnswers.STF_Ward} like "*"&{?Ward}&"*" and
{vweShowAnswers.ANS_QId} in ["194"]
ths doesn't - I get a conversion error
{vweShowAnswers.STF_Community} like "*"&{?Community}&"*" and
{vweShowAnswers.STF_Ward} like "*"&{?Ward}&"*" and
{vweShowAnswers.ANS_QId} in [{?skill}]
IP Logged
