asp.net水晶报表-主从表关联问题

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

一、使用视图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();

}

http://skylaugh.cnblogs.com/archive/2006/05/22/406520.html

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>