Viewing 7 posts - 16 through 22 (of 22 total)
I'm sorry! It didn't work for me. I get a syntax error if I write this statement.
June 27, 2008 at 9:09 am
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?
June 27, 2008 at 8:56 am
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...
June 27, 2008 at 7:40 am
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))
June 25, 2008 at 2:03 pm
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'
June 25, 2008 at 1:52 pm
=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...
June 25, 2008 at 1:48 pm
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
June 20, 2008 at 7:24 am
Viewing 7 posts - 16 through 22 (of 22 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy