Avatar of BobRosas
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?
SSRSMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Simone B

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Simone B

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
BobRosas

ASKER
Worked like a charm!  Thank you so much!
BobRosas

ASKER
You make it look so easy!  Thanks again!
Simone B

You're welcome!

Simone
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes