水晶报表数据重复
CrystalReportSource1.ReportDocument.SetDatabaseLogon("sa", "sa", @".\zhao", "ZsOA_SQL");
string sql = "SELECT dbo.tUsers.UserName, dbo.tUsers.UserPassword,dbo.tUsers.RealName, dbo.tSysLogs.UserName AS Expr1, dbo.tSysLogs.EventContent,dbo.tSysLogs.UpdateTime,dbo.tUsers.UserID FROM dbo.tUsers LEFT JOIN dbo.tSysLogs ON dbo.tUsers.UserID =dbo.tSysLogs.UserID WHERE (dbo.tUsers.UserID =12) AND (dbo.tSysLogs.UserName = 'Cr')";
string DBConfig_sql = @"Data Source=.\zhao;Initial Catalog=ZsOA_SQL;User ID=sa;Password=sa";
DataSet ds = new DataSet();
SqlConnection sqlCon = new SqlConnection(DBConfig_sql);
SqlCommand sqlCmd = new SqlCommand(sql, sqlCon);
SqlDataAdapter sqlAd = new SqlDataAdapter();
sqlAd.SelectCommand = sqlCmd;
sqlAd.Fill(ds, "sql");
CrystalReportSource1.ReportDocument.Load(Server.MapPath("CrystalReport3.rpt"));
CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables["sql"]);
CrystalReportSource1.DataBind();
CrystalReportViewer1.ReportSource = CrystalReportSource1;
CrystalReportViewer1.DataBind();
头疼一天了!~
------解决方案--------------------你的SQL语句在数据库中执行时有没有重复呢?
表之间有没有设置关系?