public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
MonthlyProjectExpReport rpt = new MonthlyProjectExpReport();
rpt.Site = this.Site;
return(rpt);
}
private void ProjectExpensesMainReport_Load(object sender, EventArgs e)
{
DataTable table = new DataTable();
MySqlDataReader reader = null;
table.Columns.Add("Project_Name", typeof(string));
table.Columns.Add("Client_Name", typeof(string));
table.Columns.Add("No_of_Events", typeof(int));
table.Columns.Add("Expense", typeof(double));
try
{
reader = DBConnection.getData(qry);
if (reader.HasRows)
{
while (reader.Read())
{
table.Rows.Add(reader.GetString("proj_name"), reader.GetString("name"), reader.GetInt32("nos"), reader.GetDouble("exp"));
}
if (reader != null)
{
if (!reader.IsClosed)
{
reader.Close();
}
}
MonthlyProjectExpReport rpt = new MonthlyProjectExpReport();
rpt.Database.Tables["ProjExp"].SetDataSource(table);
crvProjExpMainViewer.ReportSource = null;
crvProjExpMainViewer.ReportSource = rpt;
}
else
{
if (reader != null)
{
if (!reader.IsClosed)
{
reader.Close();
}
}
MessageBox.Show("No records yet!", "Project Expense Reporting", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception exc)
{
if (reader != null)
{
if (!reader.IsClosed)
{
reader.Close();
}
}
MessageBox.Show("No records yet!\n" + exc, "Project Expense Reporting", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}