I'm using SQL Sever Reporting Services. I have code and I want to add 2 dropdown parameters. It worked for the first one (@Supervisor) but when I added code for @Dept . I get the error…
Could not update a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct.
So I stripped out most of the code and I still get the error with just this…
WHERE (DeptID = @Dept) OR
(@Dept = ' All')
What am I doing wrong?