动态配置水晶报表数据源的问题。错误信息:无效报表源
蝈蝈俊 2003-10-14 10:54:45 代码如下:
this.crystalReportViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
this.reportDocument1 = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
private void Form1_Load(object sender, System.EventArgs e)
{
reportDocument1.Load(@"E:\mydoc\Visual Studio Projects\WindowsApplication1\WindowsApplication1\rpt2.rpt");
SqlConnection conn = new SqlConnection("uid=sa;pwd=test;initial catalog=testDatabase;data source=(local);Connect Timeout=90");
conn.Open();
string SelectCmdString = "select ProductName,BookISBN,productNum,MarketPrice from v_bill_of_lading";
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(SelectCmdString, conn);
DataSet ds1 = new DataSet();
mySqlDataAdapter.Fill(ds1);
reportDocument1.SetDataSource(ds1);
crystalReportViewer1.ReportSource = reportDocument1;
conn.Close();
}
说明:
E:\mydoc\Visual Studio Projects\WindowsApplication1\WindowsApplication1\rpt2.rpt 这个报表文件没有问题,我用水晶报表设计器打开,可以看到报表的数据。