I have a listbox in my asp.net form that I allow mulitple items to be selected. The items are passed back to my report through CategoryString Parameter. I want my SQL to return all the items selected (i.e. Clothing, Tools, Components...)
Under the report data tab I have the following sql:
WHERE (Year = @Year) AND (MonthNumberOfYear = @Month) AND (Category IN ([+ Parameters!CategoryString.Value +]))
The default CategoryString is set to "Components"
When I run the SQL in the Data Tab window I get the following message:
Invalid Column Name '+ Parameters!CatagoryString.value +'