title: How to add up row totals in report viewer
body: <p>I'm new to reporting and the jargon that goes with so I will try to draw it insted of write it.</p>
  
  <pre><code>|         |   A   |   B   |   C   |   D   |   E   |
  -------------------------------------------------
  | Apples  |   1   |   3   |   6   |   2   |  12   |
  -------------------------------------------------
  | Oranges |   3   |   2   |   4   |   1   |  10   |
  -------------------------------------------------
  | Bananas |   5   |   3   |       |   1   |   9   |
  -------------------------------------------------
  |         |       |       |       |       |  31   |
  </code></pre>
  
  <p>I need to sum up the last column <code>E</code> where I indicated <code>31</code>. The cells with values <code>12</code>,<code>10</code>,<code>9</code> are obtained by <code>=Sum(Fields!A.Value + Fields!B.Value + Fields!C.Value + Fields!D.Value)</code>.</p>
  
  <p>I can't change the sql query and/or the dataset that is used. Does any one have a suggestion? Thanks!</p>
  
  <p>EDIT:
  I've added a function to the code</p>
  
  <pre><code>Public Total_lookup_Sum As Integer = 0 
  
  Public Function Lookup_Sum(ByVal value As Integer) As Integer
  
    Total_lookup_Sum = Total_lookup_Sum + value     
  
    Return Total_lookup_Sum 
  
  End Function
  </code></pre>
  
  <p>and calling like this <code>Code.Equals(ReportItems!txtFruitTotal.Value)</code> but I get <code>FALSE</code>.</p>