public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { _cr_jobFair rpt = new _cr_jobFair(); rpt.Site = this.Site; return(rpt); }
private void jfReport() { _report a = new _report(); string iQry = @"SELECT (select min(event_date) from jobfair2 where event_date between '{0}' and '{1}') `min`, (select max(event_date) from jobfair2 where event_date between '{0}' and '{1}') `max`, event_date, host, concat(surname, ', ', firstname, ' ', middlename) `name`, brgy `address`, sex `gender`, cp_no `tel_no`, position `job_position`, hiring_company, jobsite `location`, `status`, remarks FROM jobfair2 where event_date between '{0}' and '{1}' and host like '%%{2}%%'"; string qry = string.Format(iQry, dateTimePicker1.Text, dateTimePicker2.Text, textBox1.Text); dataset ds = new dataset(); using (MySqlConnection conn = new MySqlConnection(DBConn.connstring)) { conn.Open(); MySqlCommand cmd = new MySqlCommand(qry, conn); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds, ds.Tables["jobFair"].TableName); _cr_jobFair rep = new _cr_jobFair(); rep.SetDataSource(ds); a.crystalReportViewer1.ReportSource = rep; a.ShowDialog(); } }