I'm sorry! It didn't work for me. I get a syntax error if I write this statement.

It doesn' take .Value with JOIN.

the main problem is how would I know how many items in the Multi-value drop down user has selected?

This is how it worked!

Go to the Properties of the Text Box or rectangle, Visibility tab and

use the expression-

=Globals.PageNumber <> 1

So the parameters are now visible only on the...

It did work! I think I didn't refresh the first time!

=COUNT(IIF(Fields!Status.Value = "C" And Fields!Race.Value = "W", Fields!Status.Value, Nothing))

In other words, how would I write this count in the footer of reporting services-

select Count(*) From tableA Where status = 'C'

and race = 'B'

=COUNT(IIF(Fields!Status.Value = "C", Fields!Status.Value, Nothing))

worked for me, thanks

Now I have another addition to this.

How about if I need the two conditions-

Fields!Status.Value = "C" AND Fields!Race.Value = "W"

this statement is not...

Thanks for the link!

The article says we coudl set EnableReportDesignClientDownload to True/False to enable/disable it. You have any idea where to find it/

thanks again!

Singh