title: sum total of column in rdlc report footer
body: <p>I have dataset1 contains : ( name - price ) in rdlc report and textbox1 placed in the footer of the report. I tried to sum the total of column (price) but I get error :</p>
  
  <blockquote>
    <p>Severity  Code    Description Project File    Line    Suppression State
    Error<br>
    The Value expression for the text box ‘Textbox1’ references
    report item 'price' in an aggregate expression with a scope.  A scope
    is not allowed on aggregates in the page header or footer which
    reference report items</p>
  </blockquote>
  
  <p>here is the expression I used :</p>
  
  <pre><code>=SUM(reportitems!price.Value, "dataset1")
  </code></pre>
  
  <p>how to sum the column price and show the result in textbox1 in the footer ?</p>