title: How to apply parent group for multiple datasets in SSRS VS2008
body: <p>I have been battling this issue for days without success. I have a very tricky format of a report i need to achieve but the main thing is that all the datasets will need to be grouped by 1 parent. I'll attempt to explain...</p>
  
  <p>Say we have dataset1, dataset2. Both have AccountNumber as common field(parent). </p>
  
  <p>I need both datasets to be used in the format/layout of the report but grouped together by AccountNumber, something like this.</p>
  
  <pre><code>[Report Header Data]
  
  [AccountNumber Group]
  
  Dataset1
  Dataset2
  
  [end AccountNumber Group]
  </code></pre>
  
  <p>What is the best way to achieve this? The format of the report has been a major road block on grouping thus making me split the data into multiple datasets, group all them together by accountnumber and then create a custom format per dataset in the report. The flow of the report may be something like this</p>
  
  <pre><code>[Report Header Data]
  
  [AccountNumber Group]
  [tablix1]
  Dataset1
  [tablix1]
  
  [tablix2]
  Dataset2
  [tablix2]
  
  [end AccountNumber Group]
  </code></pre>
  
  <p>Looking forward to the discussion on this!</p>