＋设为首页 ＋添加到收藏夹
代码如下:
private void Viewer()
{
CrystalReport1 oRpt; // create new report object
oRpt = new CrystalReport1();// create new instance of the report object
SQL_paper="SELECT * FROM stock where name=" + DropDownList1.SelectedItem.Text + "";
oleDbDataAdapter1.SelectCommand.CommandText=SQL_paper;
oleDbDataAdapter1 = new OleDbDataAdapter(SQL_paper,oleDbConnection1);
oleDbDataAdapter1.Fill(dataSet21.Tables[0]);
int_year=Convert.ToInt16(DropDownList2.SelectedItem.Text);
SQL_ream_s="SELECT date, day_r, day_s, night_r, night_s, rcv_r, rcv_s, bal_r, bal_s, phy_r, phy_s, remarks, name FROM dbo.transac where name="+DropDownList1.SelectedItem.Text.Trim() +" and month(date)="+int_month+" and year(date)="+int_year ;
oleDbDataAdapter2 = new OleDbDataAdapter(SQL_ream_s,oleDbConnection1);
oleDbDataAdapter2.Fill(dataSet21.transac);
oRpt.SetDataSource(dataSet21); // set the reports data source
CrystalReportViewer1.ReportSource = oRpt; // set the viewers report source to out report object
CrystalReportViewer1.SeparatePages=false;
CrystalReportViewer1.DisplayToolbar=false;
CrystalReportViewer1.DataBind(); // bind the report object and data to the report viewer
}
可能你这两个表有相同的字段,才会出现这种情况.
