public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReportUser rpt = new CrystalReportUser(); rpt.Site = this.Site; return(rpt); }
private void button1_Click(object sender, EventArgs e) { try { string query = "SELECT userID, fName,gName,mInitial,user_address,username,password,user_type FROM users"; dbcon.mysqlconnect.Open(); MySqlCommand cmd = new MySqlCommand(query, dbcon.mysqlconnect); MySqlDataAdapter adp = new MySqlDataAdapter(); DataSet dt = new DataSet(); adp.SelectCommand = cmd; adp.Fill(dt, "User"); CrystalReportUser reporting = new CrystalReportUser(); reporting.SetDataSource(dt); frmReports frmreports = new frmReports(); frmreports.crystalReportViewer.ReportSource = reporting; frmreports.crystalReportViewer.Refresh(); cmd.Dispose(); adp.Dispose(); dt.Dispose(); dbcon.mysqlconnect.Close(); frmreports.ShowDialog(); } catch (Exception) { throw; } }