How to sum a field based on a condition in another field in RDLC report?
14,318
You can use an expression like this:
=Sum(CInt(IIf(Left(Fields!skuno.Value, 1) = "6", Fields!qty.Value, 0)))
Please note that you have to convert every possible values to the same type (CInt for Integer, CDec for Decimal, CDbl for Double, etc.) before aggregation.
Comments
-
Muhammad Tarique over 1 year
I have an SQL database with
skuno
andqty
columns, with thevarchar(50)
data type and anint
data type respectively.Here are the columns :
skuno qty ----------------- 78654 - 100 65495 - 120 10564 - 67 64389 - 20
I want to sum
qty
whereskuno
begins with a "6" in rdlc report.I am using this expression but getting an error :
=Sum(iif(Fields!skuno.Value like "6*", Fields!qty.Value, 0))
Where is the problem and how can I fix it?