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 |
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
 Posted - 2013-04-17 : 03:52:47
|
| I have the following in a table field which does not seem to work?=Sum(IIF(IsNumeric(Fields!SelectToAck.Value) = 1 ,1,0))The Fields!SelectToAck.Value is either NULL or a number. The stored procedure the data comes from has this field as int data type.I am simply trying to count the number of fields where the value is a number.What I am after in the end is;=Sum(IIF(IsNumeric(Fields!SelectToAck.Value) = 1 & Fields!SelectToAck.Value < Parameters!BS8418SelectToAck98_5.Value,1,0)) |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-04-17 : 09:00:32
|
I don't have an SSRS installation to test, but if you are trying to distinguish between NULLs and non-nulls, you could use the following:=Sum(IIF(IsNothing(Fields!SelectToAck.Value),0,1)) |
 |
|
|
|
|
|
Using IsNumeric in a report template