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