title: New report from two tables with reportviewer doesnt have true result
body: <p>I create a new view in SQL Server 2008 from two tables that have relation on a field. I want to create a report and do grouping on that common field.</p>
  
  <p>For example:</p>
  
  <pre><code>table1: student(ID,first-name,last-name,phone,address,...)
  table2: courses(ID,fk_ID,Course,....)
  </code></pre>
  
  <p>Now I want to have report that shows all data from both tables with grouping on ID from student table,  that must show courses information separated for every student. 
  my query is:</p>
  
  <pre><code>SELECT TOP (100) PERCENT 
      dbo.tbl_student.ID,
      dbo.tbl_student.firstname, dbo.tbl_student.lastname,
      dbo.tbl_courses.Coursename, 
      dbo.tbl_Courses.CourseDate, dbo.tbl_courses.coursetype,  
  FROM
      dbo.tbl_student LEFT OUTER JOIN
      dbo.tbl_courses ON dbo.tbl_student.ID = dbo.tbl_courses.fk_id 
  ORDER BY 
      dbo.tbl_student.firstname DESC
  </code></pre>
  
  <p>But when I create a new report from this view, it shows just one record for every group. I spent 2 hours to solve the problem but I did not succeed.
  please help me to create report from two or more tables.</p>
  
  <p><strong>Now it shows one record duplicates for several times for every group</strong></p>