title: sorting a report by subreport values
body: <p>I have a subreport that provides items and their value, with a sum of the value at the bottom. I would like to sort my main report, which is the owner of the items, by the total sum of the item value.</p>
  
  <p>I have a main report that supplies the user with a persons name and contact information. I have built a sub report that takes the person's ID and displays the name and value of items associated with them. The subreport has a sum of the items. I would like to sort this report so that the highest total value is at the top. I'm new to working with sub reports in SSRS so any help would be appreciated!</p>
  
  <p>this is my report -> type and balance are the sub report. I know that these are already sorted, but that is just coincidence and I have about a thousand rows that need to be sorted by total balance
  <a href="https://i.stack.imgur.com/ELrnH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ELrnH.png" alt="enter image description here"></a></p>