Search code examples
c#sql-serverrdlcmicrosoft-reporting

Display any value in between -1 to 1 as 0 in RDLC report

This is a sample report Group by Customer. I'm calculating the balance value as: Fields!Bill.Value-SUM(Fields!Paid.Value)

Sample Report

How to display balance Column as 0 if the value is in between -1 to 1

Solution

  • Following my comment as answer since this iif statement seems to solve your problem:

    =iif(Fields!Bill.Value-SUM(Fields!Paid.Value) < -1 OR Fields!Bill.Value-SUM(Fields!Paid.Value) > 1, Fields!Bill.Value-SUM(Fields!Paid.Value), 0)