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 |
|
kathyc
Starting Member
9 Posts |
 Posted - 2009-03-07 : 12:21:19
|
| I have a field that returns a count of the number of records with a status of "open suspect".Right now, it is returning a value of nulland I'm getting an error, How do I configuremy textbox to display a value of zero (0)if no data is found?In the Expression area of my field, I have this:=Fields!TotalOpenSuspect.Value |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-08 : 13:04:22
|
| =Sum(IIf(Fields!TotalOpenSuspect.Value=1,1,0)) |
 |
|
|
|
|
|
Using an IIF Statement