Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JoanneRobinson
Starting Member
2 Posts |
 Posted - 2004-11-18 : 14:46:41
|
I am trying to use this function in my report without success. This is what I am entering: = COUNT(Fields!QuizStatus.Value = 'O'). Any help will be greatly appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-18 : 14:59:10
|
| I have a similar problem. I have to count up the number of Es. I ended up doing it at the stored proc level. I created an extra column in my result set that when the previous column equalled E then this new column got a one, otherwise zero. I then do a sum in the report on this new column. It works perfectly. It seems kludgy, but I don't know of a work around.Tara |
 |
|
|
jhermiz
3564 Posts |
Posted - 2004-11-18 : 20:02:18
|
quote:
Originally posted by tduggan
I have a similar problem. I have to count up the number of Es. I ended up doing it at the stored proc level. I created an extra column in my result set that when the previous column equalled E then this new column got a one, otherwise zero. I then do a sum in the report on this new column. It works perfectly. It seems kludgy, but I don't know of a work around.Tara
You could do the following:In the details section or whatever section you are working with add the following invisible text box as a calculated field:=IIF(Fields!Blah.Value = 'E', 1, 0)Then in the footer of the group or wherever you can do this:=SUM(Fields!Blah.Value)Jon |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-18 : 20:12:44
|
| I tried that earlier this week, but that didn't work. I get this error:The value expression for the field ‘=IIF(Fields!Correction.Value = 'E', 1, 0)’ contains an error: [BC30201] Expression expected.So the field that it is referring to is my calculated field.Tara |
|
|
|
|
|
|
Aggregate Function COUNT