public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { cust_bystatus rpt = new cust_bystatus(); rpt.Site = this.Site; return(rpt); }
private void btnsubmit_status_Click(object sender, EventArgs e) { SqlConnection sqlcon = new SqlConnection(); SqlCommand sqlcomm = new SqlCommand(); try { cust_bystatus name_report = new cust_bystatus(); sqlcon = new SqlConnection(ConfigurationSettings.AppSettings["photostudioConnectionString"].ToString()); sqlcon.Open(); if (combo_status.Text == "All") { sqlcomm = new SqlCommand(); sqlcomm.Connection = sqlcon; sqlcomm.CommandType = CommandType.StoredProcedure; sqlcomm.CommandText = "cust_status_all"; sqlcomm.Parameters.Add(new SqlParameter("@from", SqlDbType.DateTime, 50)); sqlcomm.Parameters.Add(new SqlParameter("@to", SqlDbType.DateTime, 50)); sqlcomm.Parameters["@from"].Value = dtpickfrom.Text; sqlcomm.Parameters["@to"].Value = dtpickto.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) { cust_status_reportviewer.Refresh(); MessageBox.Show("No Customer between this range of any status!"); cust_status_reportviewer.ReportSource = null; return; } name_report.SetDataSource(ds1.Tables[0]); cust_status_reportviewer.ReportSource = name_report; sqlcon.Close(); sqlcon.Dispose(); combo_status.Text = ""; return; } else { sqlcomm = new SqlCommand(); sqlcomm.Connection = sqlcon; sqlcomm.CommandType = CommandType.StoredProcedure; sqlcomm.CommandText = "cust_status_report_select"; sqlcomm.Parameters.Add(new SqlParameter("@status", SqlDbType.VarChar, 50)); sqlcomm.Parameters.Add(new SqlParameter("@from", SqlDbType.DateTime, 50)); sqlcomm.Parameters.Add(new SqlParameter("@to", SqlDbType.DateTime, 50)); sqlcomm.Parameters["@status"].Value = combo_status.Text; sqlcomm.Parameters["@from"].Value = dtpickfrom.Text; sqlcomm.Parameters["@to"].Value = dtpickto.Text; SqlDataAdapter dta1 = new SqlDataAdapter(sqlcomm); DataSet ds2 = new DataSet(); dta1.Fill(ds2, "table"); int row_counts = ds2.Tables[0].Rows.Count; if (row_counts == 0) { cust_status_reportviewer.Refresh(); MessageBox.Show("No Customer of " + combo_status.Text + "Status!"); cust_status_reportviewer.ReportSource = null; return; } name_report.SetDataSource(ds2.Tables[0]); cust_status_reportviewer.ReportSource = name_report; sqlcon.Close(); sqlcon.Dispose(); combo_status.Text = ""; } } catch { } finally { sqlcon.Close(); sqlcon.Dispose(); } }