public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { SalByMonth rpt = new SalByMonth(); rpt.Site = this.Site; return(rpt); }
//salary monthly private void DataSet3(string qry) { DataTable table = new DataTable(); MySqlDataReader reader; table.Columns.Add("first_name", typeof(string)); table.Columns.Add("basic_sal_amount", typeof(double)); table.Columns.Add("allowance", typeof(double)); table.Columns.Add("etf_epf_amount", typeof(double)); table.Columns.Add("rate", typeof(int)); table.Columns.Add("hours", typeof(int)); table.Columns.Add("sal_date", typeof(DateTime)); table.Columns.Add("gross_sal", typeof(double)); table.Columns.Add("net_sal", typeof(double)); try { reader = DBConnection.getData(qry); if (reader.HasRows) { while (reader.Read()) { table.Rows.Add(reader.GetString("first_name"), reader.GetDouble("basic_sal_amount"), reader.GetDouble("allowance"), reader.GetDouble("etf_epf_amount"), reader.GetInt32("rate"), reader.GetInt32("hours"), reader.GetDateTime("sal_date"), reader.GetDouble("gross_sal"), reader.GetDouble("net_sal")); } } reader.Close(); OfficeExpensesForm.Reports.SalByMonth report = new Reports.SalByMonth(); report.Database.Tables["Sal"].SetDataSource(table); crystalReportViewer1.ReportSource = null; crystalReportViewer1.ReportSource = report; } catch (Exception exc) { MessageBox.Show(exc.ToString()); } }