SQL Reporting Services - Parameter to SQL Code

I've to got a report in SQL Reporting Services 2005.  I need to put a parameter into SQL code.

My user wants to run the report for two categories:  

1. Only Engineering
2. Everything BUT engineering.

My parameter is a drop down list.  When I got to Main Menu -> Report -> Report Parameters, in my "available values" I set it to "non queried" and typed the following:

LABEL                                               VALUE
--------------------------------              -----------
Engineering Only                              %ENG%
Everything But Engineering              %<here where I'm not sure what to put>

In my code I say:
WHERE category like @Param

I can get "all categories including engineering" or limit them to "only engineering"

But I'm having difficulty figuring out how to use the same parameter to get everything but engineering at the same time.

What I want to say is:
If @Param = "ENG" use the LIKE '%ENG%' operator
if @Param = "NONENG" use the NOT LIKE '%ENG%' operator

But I'm not sure how to do that in the SQL statement.

I could work around the problem by creating two reports, naming them "Engineering Report" and "NON Engineering Report" and just get rid of the parameter altogether.

But I'd really like to learn if there is some other way this can be done, with only one report.

Is there an SRS expert who can direct me to learning my next level of parameter knowledge?
Start Free Trial