public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { UserEfficiencyReport rpt = new UserEfficiencyReport(); rpt.Site = this.Site; return(rpt); }
private void runquery2(string query) { MySqlDataReader reader; DataTable table = new DataTable(); table.Columns.Add("u_name", typeof(string)); table.Columns.Add("Total_logged_in_hours", typeof(Double)); table.Columns.Add("Total_work_hours", typeof(Double)); table.Columns.Add("efficiency", typeof(Double)); try { reader = Core.DBConnection.getData(query); if (reader.HasRows) { while (reader.Read()) { table.Rows.Add(reader["u_name"].ToString(), Double.Parse(reader["diff"].ToString()), Double.Parse(reader["work_hour_sum"].ToString()), 100 * Double.Parse(reader["diff"].ToString()) / Double.Parse(reader["work_hour_sum"].ToString())); } } reader.Close(); UserEfficiencyReport sample = new UserEfficiencyReport(); sample.Database.Tables["AttedanceDSet"].SetDataSource(table); crystalReportViewer1.ReportSource = null; crystalReportViewer1.ReportSource = sample; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } }