RDLC expression error
-
I wasn't sure what message board I should post this on, since none of the CodeProject boards seem to allow for the VS reports. In my RDLC report, I'm trying to negate a decimal value when another field is null. I used this expression: =IIf(IsDBNull(Fields!dst_ledgeritem_fk.Value), -Fields!dispamount.Value, Fields!dispamount.Value) However, when the IsDBNull(...) evaluates to true, the cell on the published report shows "#Error". When it evaluates to false, the plain old "Fields!dispamount.Value" displays perfectly. I've tried several variations for the "True" part of the expression: -Fields!dispamount.Value 0.0 - Fields!dispamount.Value 0.0 - CDbl(-Fields!dispamount.Value) All of them turn up "#Error". What am I doing wrong? Is there a way to get more useful information out of the report than just the useless token "#Error"? Thanks in advance.