一、使用視圖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();
   cmd1.fill(ds,"meeting");

   // sqldataadapter cmd2 = new sqldataadapter("select * from realplan where rplanid in (select top 10000 planid from ("+sqlstr+")as  a order 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();
  
  }