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();
}
}
