Unanswered: Printing summarized numbers in Reporting Services
I am new at Reporting Services. I've always used Crystal Reports. I have a textbox in a matrix containing the following expression: =IIF(Sum(Fields!Expr1.Value) > 0, Fields!Expr1.Value,0) where Expr1 is the result of the count(*) funtion in the dataset sql statement. This will print a 0 on the report if there is no value for that particular item. It looks nice, but this makes the subtotals not add up correctly. The subtotal appears to be just the first value > 0 that is found, instead of adding up all the values. If I change the expression to =Sum(Fields!Expr1.Value) the subtotals work, but the report doesn't look as nice. Anyone know what my roadblock might be?