title: Crystal report hierarchical grouping
body: <p>I am facing a series issue in creating a report that shows parent/child content and showing the summary and I am having a problem in doing that. We are working on some sort of an accounting report called "income statement" in which certain types of accounts are grouped together and being putted under a group. Within the report, I have to show the group name at the top then listing the the account name/account value pair associated with the group beneath it and of course at the end of each group there will be a summary. The problem comes from this side, I may have a group that consists of both accounts and other groups that contains other accounts which will result in a form of tree, for example, root -> group 1 -> (account 1, account 2, group 2 - > (account 3, account 4)), here I am having a root group containing a group called group 1 which including 2 accounts, account 1 and account 2, and another group called group 2 which contains 2 accounts, account 3, and account 4. 
  According to the above explanation I do not know in advance the depth of the group levels and as a result I do not know how many groups to create with the crystal report at design time because such group creation needs to be dynamic. I searched and googled and I found a solution called hierarchical grouping made through crystal report and it works 100% fine in creating parent/child hierarchy with any hierarchical depth, however, it has a problem it does not include the child group within the parent group, however, it consider and handle each group as a separate group. For example, it will create the above within the report as</p>
  
  <p><strong>group header (root group)</strong><br>
  <strong>group footer (root group) (root group summary) 3500 USD</strong><br>
  <strong>group header (group 1)</strong><br>
  detail -> (account 1/1000 USD -> account 2/1200 USD)<br>
  <strong>group footer (group 1) (group 1 summary) 3500 USD</strong><br>
  <strong>group header (group 2)</strong><br>
  detail (account 3/800 USD -> account 4/500 USD)<br>
  <strong>group footer (group 2) (group 2 summary) 1300 USD</strong><br></p>
  
  <p>The crystal knows which child is included within which parent and even when calculating summary it takes into account the summary of its childs. What I need is to make the summary of the parents come after its childs' summary like this:</p>
  
  <p><strong>group header (root group)</strong><br>
  <strong>group header (group 1)</strong><br>
  detail (account 1/1000 USD -> account 2 1200/USD)<br>
  <strong>group header (group 2)</strong><br>
  detail (account 3/800 USD -> account 4/500 USD)<br>
  <strong>group footer (group 2) (group 2 summary) 1300 USD</strong><br>
  <strong>group footer (group 1) (group 1 summary) 3500 USD</strong><br>
  <strong>group footer(root group summary) 3500 USD</strong></p>
  
  <p>Bear in mind I do not know the level of groups in advance</p>