public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { TaskEfficiency rpt = new TaskEfficiency(); rpt.Site = this.Site; return(rpt); }
private void reportmethd2(string que) { DataTable table = new DataTable(); MySqlDataReader reader = null; table.Columns.Add("First_Name", typeof(string)); table.Columns.Add("Basic_salary", typeof(float)); table.Columns.Add("OT_rate", typeof(float)); table.Columns.Add("OT_amount", typeof(float)); try { reader = DBConnection.getData(que); if (reader.HasRows) { while (reader.Read()) { table.Rows.Add(reader.GetString("first_name"), reader.GetFloat("basic_salary"), reader.GetFloat("ot_rate")); } if (reader != null) { if (!reader.IsClosed) { reader.Close(); } } TaskEfficiency rpt = new TaskEfficiency(); rpt.Database.Tables["StaffSal"].SetDataSource(table); crystalReportViewer1.ReportSource = null; crystalReportViewer1.ReportSource = rpt; } else { if (reader != null) { if (!reader.IsClosed) { reader.Close(); } } MessageBox.Show("No records yet!", "Event task Reporting", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception exc) { if (reader != null) { if (!reader.IsClosed) { reader.Close(); } } MessageBox.Show("No records yet!\n" + exc, "Event task Reporting", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }