<div>
I apologize that I did not close this earlier. &nbsp;Thanks Dale your return reply worked for me and my issue is solved.<br />
<br />
Thanks for your help.
</div>


I apologize that I did not close this earlier.  Thanks Dale your return reply worked for me and my issue is solved.

Thanks for your help.

<div>
<div class="content wysiwyg-content">
Good Morning Experts!<br />
<br />
My dilemma does not &quot;seem&quot; to difficult to solve. &nbsp;Unfortunately I have spent too much time trying to find a solution. Can you help?<br />
<br />
I have a drop down list for the the User to select a numerical value or &quot;All&quot; to get data for all of the numerical values. &nbsp; I am envisioning the coding for this happening at the end of the where clause.<br />
<br />
...AND &nbsp; If @year &lt;&gt;&nbsp;'All' (meaning a year has been selected) then y.year = @year<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; If @year = 'All' then I don't want to restrict by the year...just get all records<br />
<br />
This &quot;feels&quot; like a case statement but I have had no luck. &nbsp;Do you have any suggestions?<br />
<br />
Thanks,<br />
jimbo99999
</div>
</div>


Good Morning Experts!

My dilemma does not "seem" to difficult to solve.  Unfortunately I have spent too much time trying to find a solution. Can you help?

I have a drop down list for the the User to select a numerical value or "All" to get data for all of the numerical values.   I am envisioning the coding for this happening at the end of the where clause.

...AND   If @year <> 'All' (meaning a year has been selected) then y.year = @year
              If @year = 'All' then I don't want to restrict by the year...just get all records

This "feels" like a case statement but I have had no luck.  Do you have any suggestions?

Thanks,
jimbo99999

SSRS - Query Help with DropDown list

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.