public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
DateWiseStudentCrystalReport rpt = new DateWiseStudentCrystalReport();
rpt.Site = this.Site;
return(rpt);
}
private void DateWiseStudentReport_Load(object sender, EventArgs e)
{
using (con = new SqlConnection(ConStr))
{
using (adapter = new SqlDataAdapter("select * from Student", con))
{
dt = new DataTable();
adapter.Fill(dt);
DateWiseStudentCrystalReport dwr = new DateWiseStudentCrystalReport();
dwr.SetDataSource(dt);
crystalReportViewer1.ReportSource = dwr;
}
}
}
private void dateTimePicker2_ValueChanged(object sender, EventArgs e)
{
using (con = new SqlConnection(ConStr))
{
using (com = new SqlCommand("select * from Student where doa between '" + dateTimePicker1.Value.ToString() + "' and '" + dateTimePicker2.Value.ToString() + "'", con))
{
using (adapter = new SqlDataAdapter(com))
{
dt = new DataTable();
adapter.Fill(dt);
DateWiseStudentCrystalReport dwr = new DateWiseStudentCrystalReport();
dwr.SetDataSource(dt);
crystalReportViewer1.ReportSource = dwr;
}
}
}
}
