crystalreport problem
-
hi all!! I am on a project that need show the fields that have a DB, but in a APP of Desktop I haven't problem to do this. Now in ASP I don't know do that. In a simple way to show what I do, I drop yours this code, that try to fill a dataset to show then in a crystalR. DataSet ds = new DataSet(); sqlConn = ConnectionPool.GetConnection(); SqlTransaction sqlTrans = sqlConn.BeginTransaction(); ds = SqlHelper.ExecuteDataset(CommandType.StoredProcedu re,"DP_GetAllEmp",sqlTrans); sqlTrans.Commit(); sqlTrans = null; ConnectionPool.ReleaseConnection(sqlConn); CrystalReport1 cr1 = new CrystalReport1(); cr1.SetDataSource(ds); CrystalReportViewer1.ReportSource = cr1; //this is the problem //in this place exploit, and said me that the report data source isn't valid if everybody have any idea, please say me
-
hi all!! I am on a project that need show the fields that have a DB, but in a APP of Desktop I haven't problem to do this. Now in ASP I don't know do that. In a simple way to show what I do, I drop yours this code, that try to fill a dataset to show then in a crystalR. DataSet ds = new DataSet(); sqlConn = ConnectionPool.GetConnection(); SqlTransaction sqlTrans = sqlConn.BeginTransaction(); ds = SqlHelper.ExecuteDataset(CommandType.StoredProcedu re,"DP_GetAllEmp",sqlTrans); sqlTrans.Commit(); sqlTrans = null; ConnectionPool.ReleaseConnection(sqlConn); CrystalReport1 cr1 = new CrystalReport1(); cr1.SetDataSource(ds); CrystalReportViewer1.ReportSource = cr1; //this is the problem //in this place exploit, and said me that the report data source isn't valid if everybody have any idea, please say me
I guess ds is returning null. Please check it out.
Regards, Sylvester G Senior Software Engineer Xoriant Solutions