private void button6_Click(object sender, EventArgs e) { _report a = new _report(); string iQry = @"select date, code, concat(surname, ', ', firstname, ' ', middlename) name, address, gender, disability, remarks from pwd where date between '{0}' and '{1}'"; string qry = string.Format(iQry, dateTimePicker1.Text, dateTimePicker2.Text, comboBox5.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["pwdReport"].TableName); _cr_pwd rep = new _cr_pwd(); rep.SetDataSource(ds); a.crystalReportViewer1.ReportSource = rep; a.ShowDialog(); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { _cr_pwd rpt = new _cr_pwd(); rpt.Site = this.Site; return(rpt); }