Link to home
Start Free TrialLog in
Avatar of BobRosas

asked on

Could not update a list of fields for the query…

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…
SELECT        LastName
FROM            vw_HrIndividuals
WHERE        (DeptID = @Dept) OR
                         (@Dept = ' All')

What am I doing wrong?
Avatar of Simone B
Simone B
Flag of Canada image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BobRosas


Worked like a charm!  Thank you so much!
You make it look so easy!  Thanks again!
You're welcome!