Expression to summarise column in RDLC report winform RRS feed

  • Question

  • In my RDLC report i am trying to create a table where i want summarise the count Containing YES & NO in "Issued_to_Maintanance" column. For this i have created first column by entering YES & NO manually and for the next column i have entered this expression

     =Sum(IIf(Fields!Issued_to_Maintanance.value Like "YES",1,0),"DataSet1")

    How ever i am not getting the desired out put , below image is what it looks like , kindly help me how to correct this

    Thursday, July 30, 2020 11:00 AM