public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
AttendanceReport rpt = new AttendanceReport();
rpt.Site = this.Site;
return(rpt);
}
public void setReport(string qry)
{
MySqlDataReader reader = null;
DataTable dataTable = new DataTable();
dataTable.Columns.Add("StaffID", typeof(int));
dataTable.Columns.Add("FirstName", typeof(string));
dataTable.Columns.Add("LastName", typeof(string));
dataTable.Columns.Add("InTime", typeof(DateTime));
dataTable.Columns.Add("OutTime", typeof(DateTime));
dataTable.Columns.Add("TotalHours", typeof(TimeSpan));
dataTable.Columns.Add("EffectiveHours", typeof(int));
try
{
reader = DBConnection.getData(qry);
if (reader.HasRows)
{
while (reader.Read())
{
dataTable.Rows.Add(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetDateTime(3), reader.GetDateTime(4), reader.GetTimeSpan(5), reader.GetInt32(6));
}
}
reader.Close();
AttendanceReport rpt = new AttendanceReport();
rpt.Database.Tables["DataTable1"].SetDataSource(dataTable);
crystalReportViewer1.ReportSource = null;
crystalReportViewer1.ReportSource = rpt;
}
catch (Exception exc)
{
MessageBox.Show("Something went wrong!\n" + exc, "Report generator", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
