janine.rawnsley (5/7/2008)

---

Select {col1, Col2, ...Coln} From {Table}

Where NOT (Department = 2 And Category2 = 'B')

And NOT (Department = 2 And Category3 = 'C')

And NOT (Department = 3 And Category1...

Chris,

Thanks for your reply. The truth is that there are two categories in the real report I'm attempting...I tried to simplify the example. I may have muddled things...

Thanks for the reply.

Unfortunately, SSRS didn't like me trying to add a number and text. It did work if I tried with 2 numbers (and used the sum as...

I just did more research on the parenthesis problem in SSRS...it's not a bug, but an annoyance of Reporting Services Query Designer.

However, I tried it in the Generic...

Thanks for the reply.

OK...that's what I was thinking, too. However, when I try it in SQL Server Reporting Services, it refuses to view the two conditions together as one...