title: RRSR Sorting i got "a sort expression for the tablix4 includes an aggregate function"
body: <p>i add you my view of my report</p>
  
  <p><a href="http://s3.subirimagenes.com:81/imagen/previo/thump_7631306captura.png" rel="nofollow noreferrer">a busy cat http://s3.subirimagenes.com:81/imagen/previo/thump_7631306captura.png</a></p>
  
  <p>You can see that the group parent is NOM CLIENTE (ACCOUNT) after it has a
  child group called fecha(date) after every fecha(date) has a few pro
  code (product code), and every pro code has a cantidad(quantity), and
  every (pro codigo * cantidad) (product code * quantity) has its
  importe(amount) so, every fecha(date) has its importe (its total
  quantity bought that day) now every client has a total quantity (all
  his/her purchases) and now i want to sort my report but this last
  total quantity, you could see</p>
  
  <pre><code>837,25000
  549,60000
  1004,0000
  369,50000
  464,50000
  </code></pre>
  
  <p>the order should be:</p>
  
  <pre><code>1004,0000
  837,25000
  549,60000
  464,50000
  369,50000
  </code></pre>
  
  <p>when i do a sorting on the upper left corner and i put this function on the sort tab</p>
  
  <p><code>=Sum(Fields!importe.Value)</code> </p>
  
  <p>i get this message:</p>
  
  <blockquote>
    <p>an error ocurred during local report processing. the definition of the
    report /best_accounts is invalid A sort expression for the tablix
    'Tablix4' includes an aggregate function. Aggregate functions cannot
    be used in data row sort expressions.</p>
  </blockquote>
  
  <p>then how can i sorted as i want?</p>