public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
AttendanceDateBetween rpt = new AttendanceDateBetween();
rpt.Site = this.Site;
return(rpt);
}
private void btnAttendanceBetweenReport_Click(object sender, EventArgs e)
{
DataSet dsAttendance = Connection.GetDataSet("GetAttendanceBetWeenDate '" + txtDateFrom.Value.Date + "','" + txtDateTo.Value.Date + "' SELECT schoolname, schooladdress, affiliate_by, logoimage FROM tbl_school");
if (dsAttendance.Tables[0].Rows.Count > 0)
{
AttendanceDateBetween cr1 = new AttendanceDateBetween();
cr1.PrintOptions.PaperOrientation = PaperOrientation.Portrait;
cr1.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter;
dsAttendance.WriteXmlSchema(@"" + Connection.GetAccessPathId() + @"Barcodes\a\AttendanceDateBetween.xsd");
cr1.SetDataSource(dsAttendance);
ShowAllReports s = new ShowAllReports();
s.crystalReportViewer1.ReportSource = cr1;
s.Show();
}
else
{
MessageBox.Show("Attendance Not Registered.");
return;
}
}