一、使用视图meeting将多表关联整合在一起 二、通过Sql语句筛选数据 三、建立和主从表的关联 四、注意在CrystalReport1表中插入子报表的时候,一定要将主从表的关联字段设置好,否则出乱子 主体代码如下: /// <summary> 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); //Create the relation between the Authors and Titles tables. //binding reportViewer this.CrystalReportViewer1.ReportSource = oCR; //Close the connection. |
水晶报表主从表的关联
<%
if request("infoid")<>"" then
set rs=conn.execute("select * from nproduct where id="&request("infoid"))
if not (rs.eof and rs.bof) then
proname=rs("proname")
content=rs("proinfo")
end if
rs.close
set rs=nothing
end if
%>
-----------------------------------------------------------------