C# RDLC Reports - How to get field subtotal in unique value

See more:

C#

RDL

reporting

Hi All,

I have column planvalue and actualvalue. coloum has repeated values for jobno i wanted sum at bottom of the column such that it takes

jobno  planvalue    actualvalue
1        3000          2000
         3000           500
         3000           500
2        5000          3000
         5000          2000
3        2000          1000
         2000           500
         2000           250
         2000           250
  
      (sum)             actualTotal

no problem in actualTotal.
how can i get (sum) such that (3000+5000+2000)=10000

ie. single value from group jobno


sum(3000+2000+5000) that is unique values or Groupby jobno value single time
Any help is greatly appreciated.

Thank you and more power.