title: Report only shows one record while the DataTable having many records
body: <p>I'm using <code>ReportViewer</code> in my C# project. I have a problem when displaying a report which shows Employee Turnover Ratios monthly basis.</p>
  
  <p>The problem is even my <code>DataTable</code> populates several records, the report shows only one record. </p>
  
  <p>This is the query behind the report...</p>
  
  <pre><code>//To get all months in the given period (from @startDate to @endDate)
      WITH x AS 
      (
      SELECT CAST(@startDate AS DATE) AS Months
      UNION ALL
      SELECT DATEADD(m, 1, Months) AS Months 
      FROM x 
      WHERE (Months &lt; @endDate)
      )
      , 
  
  //Here I use GETNOOFEMPS() function to get the no of active employees which were in the month
      y AS                        
      (
      SELECT Months, CAST(dbo.GETNOOFEMPS(Months) AS DECIMAL(9, 2)) AS NoEmpsAtBegining, CAST(dbo.ETOR(DATEADD(s, - 1, DATEADD(mm, DATEDIFF(m, 0, Months) + 1, 0))) 
      AS DECIMAL(9, 2)) AS NoEmpsAtEnd
      FROM x 
      )
  
  //Calculate the ratio. This returns [Month|Emps at Begining | Emps at End | resigned | Ratio]
  
  SELECT CONVERT(DATE, Months) AS [Month], NoEmpsAtBegining, NoEmpsAtEnd, dbo.GetResignEmployees(Months) AS NoEmpsResigned, 
  CAST(dbo.GetResignEmployees(Months) / ((NoEmpsAtBegining + NoEmpsAtEnd) / 2) * 100 AS DECIMAL(9, 2)) AS EmployeeTurnOverRatio
  FROM y 
  </code></pre>
  
  <p>Even when I run this in DataAdapters query builder its runs giving the desired out put. But after I use it in <code>RDLC</code> and then viewing the report, it just shows only one record!</p>
  
  <p>How to solve this problem please?</p>
  
  <p>This is how I view the report...</p>
  
  <pre><code>    private void btnShowReport_Click(object sender, EventArgs e)
      {
          var startMonth = dtpStartMonth.Value.Month +"/" + "01"  + "/" + dtpStartMonth.Value.Year;
          var endMonth = dtpEndMonth.Value.Month + "/" + "01" + "/" + dtpEndMonth.Value.Year;
          // TODO: This line of code loads data into the 'DataSetEmployeeTurnover.DataTable1' table. You can move, or remove it, as needed.
          this.DataTable1TableAdapter.Fill(this.DataSetEmployeeTurnover.DataTable1,startMonth,endMonth);
  
          this.reportViewer1.RefreshReport();
      }
  </code></pre>