public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
_cr_colReport2 rpt = new _cr_colReport2();
rpt.Site = this.Site;
return(rpt);
}
private void collReporty()
{
_report a = new _report();
string iQry = @"SELECT
date `DATE`,
code `CODE`,
concat(surname, ', ', firstname, ' ', middlename) `NAME`,
sex `GENDER`,
dob `BOD`,
mother `MOTHERNAME`,
father `FATHERNAME`,
brgy `ADDRESS`,
cp_no `CONTACT`,
school `SCHOOL`,
yearlevel `YEAR`,
ave `AVE`,
status `STATUS`
FROM schoolar_coll
where date between '{0}' and '{1}'
and brgy like '%%{2}%%'
and school like '%%{3}%%'
and status like '%%{4}%%'
group by code";
string qry = string.Format(iQry, dateTimePicker1.Text, dateTimePicker2.Text, comboBox5.Text, textBox6.Text, comboBox1.Text);
string datasetTable = "colReport";
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[datasetTable].TableName);
_cr_colReport2 rep = new _cr_colReport2();
rep.SetDataSource(ds);
a.crystalReportViewer1.ReportSource = rep;
a.ShowDialog();
}
}
