jeebukarthikeyan
asked on
Expression in report viewer
hi,
i have created 2 expresions
="$" + Iif(Fields!AMTVARRSN.Value .ToString( ).IndexOf( "NA")>=0," 0.00",Fiel ds!TRANAMT .Value)
if AMTVARRSN.Value.ToString() .IndexOf(" NA")>=0,
then print "0.00", othere wise print Fields!TRANAMT.Value...thi s is working fine
next i need to take the sume of above value
=Sum(Fields!TRANAMT.Value) --this line fail because its always doing the sum of TRANAMT.Value
indeed i need to take the sum from the result of this expression
="$" + Iif(Fields!AMTVARRSN.Value .ToString( ).IndexOf( "NA")>=0," 0.00",Fiel ds!TRANAMT .Value)
thax
b u d d h a
i have created 2 expresions
="$" + Iif(Fields!AMTVARRSN.Value
if AMTVARRSN.Value.ToString()
then print "0.00", othere wise print Fields!TRANAMT.Value...thi
next i need to take the sume of above value
=Sum(Fields!TRANAMT.Value)
indeed i need to take the sum from the result of this expression
="$" + Iif(Fields!AMTVARRSN.Value
thax
b u d d h a
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.