Our Training Programs

All contents are copyright of their authors.

RDLC Expression For currency comparison

RDLC Expression For currency comparison

mjasri

5yAsked Dec 23, 2020, 5:02 AM1.2kReports using C#

Dears Gentlmen,

I need your support .

this formula is giving #error

in rdlc report expression .

I am comparing the currancy value money for totalagreementpaid

all fields are currancy.

=IIf((Fields!new_totalagreementpaid.Value<=(Fields!new_rentfees.Value*25/100)),Fields!new_rentfeesValue.Value*15/1000,Nothing)

Please Support.

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Amit Gupta5y ago
Accepted answer
I believe that the datatype is other than numeric value, so convert it to double (CDbl) and try the below expression =IIf(CDbl(Fields!new_totalagreementpaid.Value)<= CDbl((Fields!new_rentfees.Value)*25/100), CDbl((Fields!new_rentfeesValue.Value)*15/100), Nothing)
Rajanikant Hawaldar5y ago
what is the datatype of new_totalagreementpaid and new_rentfees and new_rentfeesValue?
do you really have this column new_rentfeesValue? i am guessing this is spelling mistake
mjasri5y ago
All Fields Currancy Type and Contains Values
Rajanikant Hawaldar5y ago
which error