Error Calculating Percentages in SQL Reporting Services 2005 SP1
Posted on 2007-04-09
I have created a report in SSRS 2005 SP1 and I'm running into a problem evaluating the following expression:
When the report is built, the following error appears:
[rsRuntimeErrorInExpression] The Value expression for the textbox ‘textbox70’ contains an error: Attempted to divide by zero.
As you can see from the expression, I am making sure the denominator of my formula (Fields!xtndprce.Value) is not zero. It seems as if SSRS is evaluating the "false" part of my expression regardless of whether the condition is true or false. I have also tried "IsError" with the same results ("False" if Fields!xtndprce.Value<>0 and "#Error" if it is).
Thanks in advance.