vs2010 水晶报表 ReportDocument 如何绑定含有多个表的DataSet----阿泰老大,救命啊~~
lli00 2011-08-15 11:12:56 小弟刚接触水晶报表,做了一份,遇到一个问题。
我在主表里拖了多个数据集(3个),然后再cs中编码时,我是这样写的,
protected void BindReports(Guid USERID,Guid sDID)
{
ReportSource001.ReportDocument.Load(Server.MapPath("Report001.rpt"));
DataSet ds = getReports001Data(USERID, sDID);
ReportSource001.ReportDocument.SetDataSource(ds);
ReportSource001.DataBind();
ReportView001.ReportSource = ReportSource001;
}
public DataSet getReports001Data(Guid USERID,Guid sDID)
{
DataSet ds = new DataSet();
DbProviderFactory dbf = DbProviderFactories.GetFactory();
using (IDbConnection con = dbf.CreateConnection())
{
con.Open();
using (IDbCommand cmd = con.CreateCommand())
{
using (DbDataAdapter da = dbf.CreateDataAdapter())
{
cmd.CommandText = "select vwIFDB_ENTERPRISEINFO.*,DisplayList1.DISPLAY_NAME as ENTERPRISE_NATURE_INFO ,DisplayList2.DISPLAY_NAME as ENTERPRISEINFO_BELONG_INFO from vwIFDB_ENTERPRISEINFO left outer join vwTERMINOLOGY_List DisplayList1 on DisplayList1.NAME=vwIFDB_ENTERPRISEINFO.ENTERPRISE_NATURE left outer join vwTERMINOLOGY_List DisplayList2 on DisplayList2.NAME=vwIFDB_ENTERPRISEINFO.ENTERPRISE_BELONG where 1=1 and vwIFDB_ENTERPRISEINFO.CREATED_BY_ID='" + USERID + "' and DisplayList1.LANG = 'zh-CN' and DisplayList1.LIST_NAME = 'IFDB_ENTERPRISE_NATURE' and DisplayList2.LANG='zh-CN' and DisplayList2.LIST_NAME = 'IFDB_ENTERPRISE_BELONG'";
((IDbDataAdapter)da).SelectCommand = cmd;
da.Fill(ds, "ENTERPRISEINFO");
cmd.CommandText = "select * from vwIFDB_EXISTING_LOAN where 1=1 and CREATED_BY_ID='" + USERID + "' and DECLARE_ID='" + sDID + "'";
((IDbDataAdapter)da).SelectCommand = cmd;
da.Fill(ds, "EXISTING_LOAN");
}
}
}
return ds;
}
可是我发现,报表里根本不显示这些数据,不知道怎么了。我调试的时候,ds里有两张查出来的表,绑定上去后报表不显示。
老大们,帮帮忙吧~~小弟感激涕零啊~~~
(小弟没什么分,都给你们了)