public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
branch_income_report rpt = new branch_income_report();
rpt.Site = this.Site;
return(rpt);
}
private void btnsubmit_income_Click(object sender, EventArgs e)
{
SqlConnection sqlcon = new SqlConnection();
SqlCommand sqlcomm = new SqlCommand();
try
{
branch_income_report name_report = new branch_income_report();
sqlcon = new SqlConnection(ConfigurationSettings.AppSettings["photostudioConnectionString"].ToString());
sqlcon.Open();
sqlcomm = new SqlCommand();
sqlcomm.Connection = sqlcon;
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.CommandText = "branch_totalincome_report";
sqlcomm.Parameters.Add(new SqlParameter("@branch", SqlDbType.VarChar, 50));
sqlcomm.Parameters["@branch"].Value = combo_branchincome.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)
{
branch_income_reportviewer.Refresh();
MessageBox.Show("No branch of such name!");
branch_income_reportviewer.ReportSource = null;
return;
}
name_report.SetDataSource(ds1.Tables[0]);
branch_income_reportviewer.ReportSource = name_report;
sqlcon.Close();
sqlcon.Dispose();
combo_branchincome.Text = "";
}
catch
{
}
finally
{
sqlcon.Close();
sqlcon.Dispose();
}
}