Click here to Skip to main content
14,641,834 members
Rate this:
Please Sign up or sign in to vote.
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 , it shows 1 to each row of my table instead of total number of yes & total number of no , kindly help me how to correct this

What I have tried:

<pre>=Sum(IIf(Fields!Issued_to_Maintanance.value Like "YES",1,0),"DataSet1")
Updated 2-Aug-20 21:13pm

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

You need to add a 'Total' row at the bottom of your report design instead of a column.

Refer: Sum of Column Values in Reports Automatically Using Expression in .NET[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100