水晶报表动态赋数据源问题,还是无法解决!!!!!!!高手来给看看吧!急!分不够再加!
老大们:
我要动态的将数据源赋给报表(通过数据集xsd文件)
代码如下:
string myConnectionString = "..."
SqlConnection myConnection = new SqlConnection(myConnectionString);
string mySelectQuery = "select * from A_CK";
SqlDataAdapter myDataAdapter = new SqlDataAdapter(mySelectQuery, myConnection);
//DataSet1为用XML 架构定义语言 (XSD) 描述的DataSet架构
Dataset1 dsBill = new Dataset1();
// 连接到数据库、从数据库中获取数据然后断开数据库连接
myDataAdapter.Fill(dsBill,"A_Ck");
//实例化水晶报表
CrystalReport3 CR_Bill = new CrystalReport3();
//登录信息
CrystalDecisions.Shared.TableLogOnInfos myTableLogonInfos =
new TableLogOnInfos();
CrystalDecisions.Shared.TableLogOnInfo myTableLogonInfo =
new TableLogOnInfo();
CrystalDecisions.Shared.ConnectionInfo myConnectionInfo =
new ConnectionInfo();
myConnectionInfo.ServerName = "...";
myConnectionInfo.DatabaseName = "...";
myConnectionInfo.UserID = "...";
myConnectionInfo.Password = "...";
myTableLogonInfo.ConnectionInfo = myConnectionInfo;
myTableLogonInfo.TableName = "A_CK";
myTableLogonInfos.Add(myTableLogonInfo);
this.crystalReportViewer1.LogOnInfo = myTableLogonInfos;
//将填充的数据集传递给报表
CR_Bill.SetDataSource(dsBill);
//设置报表源,将该报表对象绑定到 Web 窗体查看器
crystalReportViewer1.ReportSource=CR_Bill;
crystalReportViewer1.RefreshReport();
问题在于,dsBill确实被填充了,其中有个叫A_CK的表,也有数据,但CR_Bill.SetDataSource(dsBill);执行之后,在CR_Bill中的dataBase.Tables.Count竟为0,报表的数据源没有表,当然也没有数据,(此时dsBill中仍有数据表)就好像CR_Bill.SetDataSource(dsBill);没起作用。
本来要用存储过程的,但连表都无法实现
各位老大帮帮忙吧,救急!!!!!!!!!!!!!!!!!!