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 |
|
cmgarnett
Starting Member
1 Post |
 Posted - 2009-07-16 : 10:51:28
|
| I have the following expression =IIF(Fields!LastName.Value Is Nothing,true,false)in my "Grouping and Sorting Properties" section under the "Visibility" "Expression" portion. I am trying to use the RunningValue function to only count the rows that aren't Null. The following is the expression that I am using in order to accomplish this but it isn't working:When I use the =IIF(Fields!LastName.Value Is Nothing, 0,RunningValue(Fields!SocialSecurityNumber.Value, CountDistinct, Nothing))Conchita Garnett |
|
|
weipublic
Starting Member
19 Posts |
Posted - 2009-07-30 : 17:17:51
|
| put the 'IIF' inside of 'RunningValue', may looks like:RunningValue(IIF(Fields!LastName.Value Is Nothing, 0, Fields!SocialSecurityNumber.Value ), CountDistinct, Nothing)) |
 |
|
|
|
|
|
How to apply a RunningValue To Non Hidden Rows