title: pass 2 resultsets as datasource to a local rdlc file
body: <p>i have 2 tables:
  Table 1: Scores</p>
  
  <pre><code>stuID  |Subject | TotalScore
  1          maths    40
  1          bio      50
  2          maths    60
  2          bio      60
  3          maths    30
  3          bio      30
  </code></pre>
  
  <p>Then Table 2: Summary</p>
  
  <pre><code>stuID  | Average | Rank
  1          45       2
  2          60       1
  3          30       3
  </code></pre>
  
  <p>Now am creating a rdlc and a reportviewer.
  How do i get the detailed scores for stu with ID 1 and also the rank to rdlc datasource and ultimately to report viewer all in a single datasource.
  example:</p>
  
  <pre><code> StuID : 1   Rank:2
  
  Report:
  subject |  Score
  maths        40
  bio          50
  </code></pre>