|
Hi all,
I am developing windows application. In this application I need to use the crystal report. I need to add the fields by programmatically. I am using dataset to bind the table values with crystal report. But when I set the datasource value to the crystalreport i am getting error that says "The report has no table". How to solve this? Here, I attached my code.
private void Form1_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = databaseconnectionstring;
StringBuilder sbSql = new StringBuilder();
sbSql.Append("SELECT ");
sbSql.Append("Face_page.[Case], Face_page.Type, Face_page.Location, Face_page.Flag, ");
sbSql.Append("Face_page.Officer, Face_page.ID, Face_page.Written, Face_page.Shift, ");
sbSql.Append("Face_page.DaysOff ");
sbSql.Append("FROM ");
sbSql.Append(" Face_page ");
sbSql.Append(" where ");
sbSql.Append("Face_page.[Case] = '71-111-1111E'");
string sql = sbSql.ToString();
DataSet ds = new DataSet();
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds, "sample");
CrystalReport4 cryReport1 = new CrystalReport4();
if(ds.Tables.Count>0) {
cryReport1.SetDataSource(ds.Tables[0]); // ----> I am getting error here..
}
crystalReportViewer1.Visible = true;
this.crystalReportViewer1.ReportSource = cryReport1;
con.Close();
}
-------------
R. Eswaran
|