title: What options am I left with SSRS for given scenario
body: <p>I have a database relationship as follow,</p>
  
  <pre><code>MasterEmployee
     EmployeeName
     ...Other Employee Details
     EmployeeAddress
         HistoryOfAddresses (dataset)
     EmployeePositions
         CurrentAndHistoryOfPositions (another dataset)
     .... other datasets
  </code></pre>
  
  <p>I need to create a SSRS report for above, I think best way is to create a master worksheet and then add a worksheet for each of child dataset.</p>
  
  <p>To achieve above I have a SQL query that returns me below,</p>
  
  <pre><code>&lt;Employees&gt;
        &lt;Employee&gt;
            &lt;ID&gt;185&lt;/ID&gt;
            &lt;Name&gt;18_108669635&lt;/Name&gt;
            ... Other attributes
  
            &lt;Addresses&gt;
                &lt;Address&gt;
                    &lt;ID&gt;1&lt;/ID&gt;
                    &lt;Location&gt;79 Baker Street&lt;/Location&gt;
                    &lt;CurrentAddress&gt;false&lt;/CurrentAddress&gt;
                &lt;/Address&gt;
                .. Other addresses
            &lt;/Addresses&gt;
            &lt;Other datasets like positions in company etc..&gt;
        &lt;/Employee&gt;
  &lt;/Employees&gt;
  </code></pre>
  
  <p>Now I am not able to figure out how can I use this dataset above to show it in a ssrs report and how ?</p>