我在水晶报表中有两个数据源,代码如下:
private void Page_Load(object sender, System.EventArgs e)
{
disp();
}
private void disp()
{ string strProvider = "Server=(local);DataBase=Eloyee;UID=sa;PWD="; CrystalReport1 oCR = new CrystalReport1(); DataSet1 ds = new DataSet1(); SqlConnection MyConn = new SqlConnection(strProvider); MyConn.Open();
string str="Select * from PFbase";
SqlDataAdapter da=new SqlDataAdapter(str,MyConn);
da.Fill(ds,"pfbase");
int mm=DateTime.Now.Month;
string strSel = String.Format("SELECT * FROM PFCount WHERE Month(PDate)="+mm+" order by EName");
SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds,"pfcount");
oCR.SetDataSource(ds);
this.CrystalReportViewer1.ReportSource = oCR;
}
PFbase表中的数据正常显示,但PFCount表中的数据则显示两遍。请高手指点:
private void Page_Load(object sender, System.EventArgs e)
{
disp();
}
private void disp()
{ string strProvider = "Server=(local);DataBase=Eloyee;UID=sa;PWD="; CrystalReport1 oCR = new CrystalReport1(); DataSet1 ds = new DataSet1(); SqlConnection MyConn = new SqlConnection(strProvider); MyConn.Open();
string str="Select * from PFbase";
SqlDataAdapter da=new SqlDataAdapter(str,MyConn);
da.Fill(ds,"pfbase");
int mm=DateTime.Now.Month;
string strSel = String.Format("SELECT * FROM PFCount WHERE Month(PDate)="+mm+" order by EName");
SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds,"pfcount");
oCR.SetDataSource(ds);
this.CrystalReportViewer1.ReportSource = oCR;
}
PFbase表中的数据正常显示,但PFCount表中的数据则显示两遍。请高手指点:
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货