<div>
Worked like a charm! &nbsp;Thank you so much!
</div>


Worked like a charm!  Thank you so much!

<div>
You make it look so easy! &nbsp;Thanks again!
</div>


You make it look so easy!  Thanks again!

<div>
You're welcome!<br />
<br />
Simone
</div>


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


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?

Could not update a list of fields for the query…

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.