public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
expense_range_report rpt = new expense_range_report();
rpt.Site = this.Site;
return(rpt);
}
private void btnsubmit_expense_Click(object sender, EventArgs e)
{
SqlConnection sqlcon = new SqlConnection();
SqlCommand sqlcomm = new SqlCommand();
try
{
expense_range_report name_report = new expense_range_report();
sqlcon = new SqlConnection(ConfigurationSettings.AppSettings["photostudioConnectionString"].ToString());
sqlcon.Open();
sqlcomm = new SqlCommand();
sqlcomm.Connection = sqlcon;
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.CommandText = "expense_report";
sqlcomm.Parameters.Add(new SqlParameter("@from", SqlDbType.DateTime, 50));
sqlcomm.Parameters.Add(new SqlParameter("@to", SqlDbType.DateTime, 50));
sqlcomm.Parameters["@from"].Value = dtpickfrom_expense.Text;
sqlcomm.Parameters["@to"].Value = dtpickto_expense.Text;
SqlDataAdapter dta = new SqlDataAdapter(sqlcomm);
DataSet ds1 = new DataSet();
dta.Fill(ds1, "table");
int row_count = ds1.Tables[0].Rows.Count;
if (row_count == 0)
{
expense_reportviewer.Refresh();
MessageBox.Show("No expense!");
expense_reportviewer.ReportSource = null;
return;
}
name_report.SetDataSource(ds1.Tables[0]);
expense_reportviewer.ReportSource = name_report;
sqlcon.Close();
sqlcon.Dispose();
expense_reportviewer.Text = "";
}
catch
{
}
finally
{
sqlcon.Close();
sqlcon.Dispose();
}
}