一、使用視圖meeting將多表關聯整合在一起
二、透過Sql語句篩選資料
三、建立和主從表的關聯
四、注意在CrystalReport1表中插入子報表的時候，一定要將主從表的關聯字段設定好，否則出亂子
主體程式碼如下：
/// <summary>
/// Bind CrystalReport
/// </summary>
/// <param name="strS">sql</param>
private void bdReport(string strS)
{
oCR = new CrystalReport1();
SqlConnection cnn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionSqlServer"]);
SqlDataAdapter cmd1 = new SqlDataAdapter(strS,cnn);
//Create and fill the DataSet.
DataSet2 ds = new DataSet2(ds);
cmd1.Fill(ds,"meeting");
// SqlDataAdapter cmd2 = new SqlDataAdapter("select * from realplan where rplanid in (select top 10000 planid from ("+sqlStr+")as a by by planid)", cnn);
SqlDataAdapter cmd2 = new SqlDataAdapter(SqlIsOper, cnn);
cmd2.Fill(ds,"realplan");
//Create the relation between the Authors and Titles tables.
ds.Relations.Add("mo",
ds.Tables["meeting"].Columns["planid"],
ds.Tables["realplan"].Columns["rplanid"]);
//binding reportViewer
oCR.SetDataSource(ds);
this.CrystalReportViewer1.ReportSource = oCR;
//Close the connection.
cnn.Close();
}