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

下面是个 水晶报表-主从表关联问题教程，撑握了其技术要点，学起来就简单多了。赶紧跟着小编一起来看看吧！

一、使用视图meeting将多表关联整合在一起

二、通过Sql语句筛选数据

三、建立和主从表的关联

四、注意在CrystalReport1表中插入子报表的时候，一定要将主从表的关联字段设置好，否则出乱子

主体代码如下：

/// summary

/// Bind CrystalReport

/// /summary

/// param name="strS"sql/param

private void bdReport(string strS)

{

oCR = new CrystalReport1();

SqlConnection cnn = new SqlConnection(""]);

SqlDataAdapter cmd1 = new SqlDataAdapter(strS,cnn);

//Create and fill the DataSet.

DataSet2 ds = new DataSet2();

(,"");

// 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);

(,"");

//Create the relation between the Authors and Titles tables.

("mo",

""""],

""""]);

//binding reportViewer

();

= oCR;

//Close the connection.

();

}