title: How to report child groups total values separately in ssrs
body: <p>I have a report in SSRS 2012 containing two groups. </p>
  
  <p>one is parent and the other one is a child group. both are row groups, parent group is according to month number (1 to 12) and child group is according to the values of a column from dataset named "State" ranging from 1 to 5. at the end of each child group, there's a total row and at the end of the report is the grand total of all child groups. </p>
  
  <p>I need to show the sum of each child group at the beginning of report body (above table) or in report header. is there any way to do that in ssrs? </p>
  
  <p>Btw child group is named "State" and parent group is "Month"</p>
  
  <p>I put this expression in a random textbox : </p>
  
  <pre><code>iif(Fields!State.Value=1, "Sum(Fields!Amount.Value, "State")", "0") 
  </code></pre>
  
  <p>but it doesn't work!</p>