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; } } } }