public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { crSched_Dep_Size_Est_Ins_Dep rpt = new crSched_Dep_Size_Est_Ins_Dep(); rpt.Site = this.Site; return(rpt); }
public void Sched_Dep_Size_Est_Ins_Dep() { try { MySqlCommand cmd = new MySqlCommand(); MySqlDataAdapter da = new MySqlDataAdapter(); DataSet DS = new DataSet(); DataTable DT = new DataTable(); Est_Ins_Dep = new crSched_Dep_Size_Est_Ins_Dep(); Est_Ins_Dep_NoData = new crSched_Dep_Size_Est_Ins_DepNoData(); GlobalVariable.MyADOConnection = new MySqlConnection(GlobalVariable.dbConnectionString); GlobalVariable.MyADOConnection.Open(); //MySQLQuery = ""; //MySQLQuery = "call sp_Sched_Dep_Size_Est_Ins_Dep ('" + GlobalVariable.Date_ + "'); "; //MySqlCommand cmd = new MySqlCommand(MySQLQuery, GlobalVariable.MyADOConnection); //cmd.ExecuteScalar(); cmd = new MySqlCommand("sp_dav_Sched_Dep_Size_Est_Ins_Dep", GlobalVariable.MyADOConnection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("Date_", GlobalVariable.Date_); cmd.CommandTimeout = 0; da.SelectCommand = cmd; da.Fill(DS, "TABLE"); if (DS.Tables[0].Rows.Count == 0) { Est_Ins_Dep_NoData.SetDataSource(DS.Tables[0]); GlobalVariable.MyADOConnection.Close(); crViewer.ReportSource = Est_Ins_Dep_NoData; } else { Est_Ins_Dep.SetDataSource(DS.Tables[0]); GlobalVariable.MyADOConnection.Close(); crViewer.ReportSource = Est_Ins_Dep; } frmReports rep = new frmReports(); rep.Dispose(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }