title: Error in finding sum of a group and Conditional Summing in SSRS Reports
body: <p>I have an SSRS Report, in the database there is a column by name <code>Total_running_hours</code>.
  There are more than one record for a single Cycle_number like more than 1 row with same <code>Cycle_numbe</code>r but different <code>Block_numbers</code> and the value in <code>Total_running_hours</code> field will be same for all the rows with same <code>Cycle_number</code>. <br>Eg. 1 Cycle number with 4 diff <code>block_numbers</code> contain same <code>Total_running_hours</code> for all 4 rows.</p>
  
  <p>Now the problem is, in the group footer if I put this field then it will show the <code>Total_running_hours</code> value only once which is correct, but my final requirement is,</p>
  
  <p>I need to get the sum of this field in the Report footer which need to display the sum group wise. No matter how many rows are there for a single <code>Cycle_number</code> it has to take only once and display the result.</p>
  
  <p>I tried in different ways like</p>
  
  <pre><code>=sum(ReportItems!textbox204.Value) // name of text box in Group footer
  </code></pre>
  
  <blockquote>
    <p>Error: Report item expressions can only refer to other report items
    within the same grouping scope or a containing grouping scope.</p>
  </blockquote>
  
  <pre><code>=sum(Fields!total_running_hours.Value,Group_name) 
  </code></pre>
  
  <blockquote>
    <p>Error: The scope parameter must be set to a string constant that is
    equal to either the name of a containing group, the name of a
    containing data region, or the name of a data set.</p>
  </blockquote>
  
  <p>Can any one please help me in getting the sum Group wise</p>
  
  <p>Thank you in advance.</p>