Reporting services sum null values

I guess this is caused by the null values returned by the query. Value and guess what Value, 0 and guess what I got the same. Any idea? Wednesday, September 14, PM. Value , 0,Fields! Value did. Sunday, April 23, AM. Thursday, July 20, PM. Hi Joe. The "IsNothing " function works preety well.

Thank you. By the way, I noticed that sometimes the data set returns non-null values, but empty strings. Thank you Joe. Tuesday, September 20, PM. The set of data specified in the expression must have the same data type. To convert data that has multiple numeric data types to the same data type, use conversion functions like CInt , CDbl or CDec.

For more information, see Type Conversion Functions. The value of scope must be a string constant and can't be an expression. For outer aggregates or aggregates that do not specify other aggregates, scope must refer to the current scope or a containing scope. For aggregates of aggregates, nested aggregates can specify a child scope. Expression can contain calls to nested aggregate functions with the following exceptions and conditions:.

Scope for nested aggregates must be the same as, or contained by, the scope of the outer aggregate. For all distinct scopes in the expression, one scope must be in a child relationship to all other scopes. The following two code examples provide a sum of line item totals in the Order group or data region. Value This works as desired. Improve this question. Add a comment. Active Oldest Votes. I made a simple report to test: This uses your expression at the detail level and mine at the summary.

Improve this answer. Ian Preston Ian Preston Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.