public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReportNonGovernmentWorkers rpt = new CrystalReportNonGovernmentWorkers(); rpt.Site = this.Site; return(rpt); }
private void FrmNonGovernmentWorkersRpt_Load(object sender, EventArgs e) { try { OleDbConnection cn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application.StartupPath + "\\dbCitizen.accdb;Persist Security Info=True"); //OleDbConnection cn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Project 2016\SeniorCitizenICTDatabase\SeniorCitizenICTDatabase\dbCitizen.accdb;Persist Security Info=True"); OleDbDataAdapter adapter = new OleDbDataAdapter("select UniqueCitizenId, CitizenFullname, OccupationType, NonGovOrganizationName, NonGovOrganizationAddress, NonGovLGA, NonGovOccupation from tblSeniorCitizen where OccupationType = 'Non-Government Worker'", cn); DataSet ds = new DataSet(); adapter.Fill(ds, "NonGovernmentWorkerRpt"); CrystalReportNonGovernmentWorkers rpt = new CrystalReportNonGovernmentWorkers(); rpt.SetDataSource(ds); crystalReportViewer1.ReportSource = rpt; } catch (Exception er) { MessageBox.Show(er.Message); } }