sql-server - MVC-报告显示冗余值

Question

我有一个使用 MVC 的网络应用程序，它从“查看”Vtasks View 中查看报告：

 SELECT        TOP (100) PERCENT dbo.tasks.task_id, dbo.tasks.task_name, dbo.tasks.task_desc, dbo.tasks.date, dbo.tasks.notes, dbo.employees.emp_name, dbo.status.state_name, dbo.users.username
FROM            dbo.departments INNER JOIN
                         dbo.tasks ON dbo.departments.dep_id = dbo.tasks.dep INNER JOIN
                         dbo.status ON dbo.tasks.state = dbo.status.state_Id INNER JOIN
                         dbo.users ON dbo.tasks.created_by = dbo.users.id INNER JOIN
                         dbo.emp_task ON dbo.tasks.task_id = dbo.emp_task.task_id INNER JOIN
                         dbo.employees ON dbo.emp_task.emp_id = dbo.employees.id
ORDER BY dbo.tasks.task_id

报告控制器：

      var reportViewer = new ReportViewer();

 reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\tasksRep1.rdlc";

            reportViewer.LocalReport.DataSources.Clear();
            reportViewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", db.Vtasks.ToList()));
            reportViewer.LocalReport.Refresh();
            reportViewer.ProcessingMode = ProcessingMode.Local;
            reportViewer.AsyncRendering = false;
            reportViewer.SizeToReportContent = true;
            reportViewer.ZoomMode = ZoomMode.FullPage;

            ViewBag.ReportViewer = reportViewer;

报告查看器：

 @Html.ReportViewer(ViewBag.ReportViewer as Microsoft.Reporting.WebForms.ReportViewer)

来自 sql server 的选择结果：

来自reportviewer的选择结果

问题是报告显示相同 task_name 的冗余 emp_name 。

我不知道是什么问题，我感谢任何帮助谢谢

标签： sql-serverasp.net-mvcreportreporting