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