Thanks Gazareth, that solution worked perfectly. Also thanks for the tip re the correct forum.

Thanks both for getting back. However your answers presume a technical knowledge that I do not currently possess!

I have a field that is bringing through a business name into my...

Thanks for taking the trouble to reply.

Will bear in mind for next time, thanks. In the end I solved this knotty conundrum via:

=Sum(Iif(Fields!transactiontime.Value = 0, 1, 0))

Which worked like a...

Thanks.

It's very simple:

One field is called transaction time, and returns a value that shows how long the transaction took place, and that can be anything from 0 to 100.

I build...

Thanks for replying - SSRS 2008 R2

Thanks for the prompt and helpful response.

However, can 'NOT IN' be used in 2008R2?

If not, is there something similar?

Thanks.

I managed to fix it and it works perfectly now: without your help this would not have been possible.

Many thanks.

Thanks very much for getting back. Your suggestion makes perfect logical sense and I'm sure will work, but:

I put the expression you suggested (amended with my fields) into the Value...

Thanks very much for taking the trouble to get back.

I have tried via indicators but am clearly doing something wrong - will keep trying.

The Wingdings solution is a neat idea...