public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
ReportTeacherStdAbsent rpt = new ReportTeacherStdAbsent();
rpt.Site = this.Site;
return(rpt);
}
public void LoadReport()
{
con = Connection.con();
con.Open();
query = "proc_teacher_absentstdlist";
cmd = new MySqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("?vfrom", dtFrom.Value.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("?vto", dtTo.Value.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("?vtid", teacherid);
cmd.Parameters.AddWithValue("?vaycode", cmbAy.Text.Trim());
DataTable dt = new DataTable();
MySqlDataAdapter adptr = new MySqlDataAdapter(cmd);
adptr.Fill(dt);
adptr.Dispose();
cmd.Dispose();
con.Close();
con.Dispose();
ReportTeacherStdAbsent rpt = new ReportTeacherStdAbsent();
rpt.SetDataSource(dt);
crystalReportViewer1.ReportSource = rpt;
}
