public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReport4 rpt = new CrystalReport4(); rpt.Site = this.Site; return(rpt); }
private void CRReloader() { calendar1.Visible = true; try { if (comboBox1.Text == "View all readings in a selected date" || comboBox1.Text == "Average Per Hour") { calendar1.SetViewMode(MonthCalendar.ViewMode.vmMonth, MonthCalendar.ViewMode.vmYear); calendar1.SetViewMode(MonthCalendar.ViewMode.vmMonth, MonthCalendar.ViewMode.vm12Years); calendar1.SetViewMode(MonthCalendar.ViewMode.vmMonth, MonthCalendar.ViewMode.vm120Years); calendar1.OnlyMonthMode = true; if (comboBox1.Text == "View all readings in a selected date") { PictureLoad(); string source = "SELECT [Systolic],[Diastolic],[CDate],[CTime],[Status] from Record WHERE [PatientID] = '" + MainForm.patientID + "' and [CDate] = #" + calendar1.SelectedDate + "#"; OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb"); con.Open(); OleDbDataAdapter adapt = new OleDbDataAdapter(source, con); DataSet ds = new DataSet(); ds.Tables.Add(); adapt.Fill(ds.Tables[0]); con.Close(); source = "SELECT * from Profile"; con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb"); con.Open(); adapt = new OleDbDataAdapter(source, con); ds.Tables.Add(); adapt.Fill(ds.Tables[1]); con.Close(); CrystalReport1 rep = new CrystalReport1(); rep.Database.Tables[0].SetDataSource(ds.Tables[0]); rep.Database.Tables[1].SetDataSource(ds.Tables[1]); crystalReportViewer1.ReportSource = rep; crystalReportViewer1.Refresh(); } else if (comboBox1.Text == "Average Per Hour") { PictureLoad(); string source = "SELECT Sys, Dias, Hour, CDate, Stat From HourTable Where PatientID ='" + MainForm.patientID + "' and CDate = #" + calendar1.SelectedDate + "#"; OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb"); con.Open(); OleDbDataAdapter adapt = new OleDbDataAdapter(source, con); DataSet ds = new DataSet(); ds.Tables.Add(); adapt.Fill(ds.Tables[0]); con.Close(); source = "SELECT * from Profile WHERE PatientID ='" + MainForm.patientID + "'"; con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb"); con.Open(); adapt = new OleDbDataAdapter(source, con); ds.Tables.Add(); adapt.Fill(ds.Tables[1]); con.Close(); CrystalReport2 rep = new CrystalReport2(); rep.Database.Tables[0].SetDataSource(ds.Tables[0]); rep.Database.Tables[1].SetDataSource(ds.Tables[1]); crystalReportViewer1.ReportSource = rep; crystalReportViewer1.Refresh(); } } else if (comboBox1.Text == "Average Per Month") { PictureLoad(); calendar1.OnlyMonthMode = false; calendar1.SetViewMode(MonthCalendar.ViewMode.vmYear, MonthCalendar.ViewMode.vmYear); calendar1.SetViewMode(MonthCalendar.ViewMode.vmYear, MonthCalendar.ViewMode.vm12Years); calendar1.SetViewMode(MonthCalendar.ViewMode.vmYear, MonthCalendar.ViewMode.vm120Years); string source = "SELECT Sys, Dias, Month, Year, Stat From MonthTable Where PatientID ='" + MainForm.patientID + "' and Year = " + calendar1.SelectedDate.Year; OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb"); con.Open(); OleDbDataAdapter adapt = new OleDbDataAdapter(source, con); DataSet ds = new DataSet(); ds.Tables.Add(); adapt.Fill(ds.Tables[0]); con.Close(); source = "SELECT * from Profile WHERE PatientID ='" + MainForm.patientID + "'"; con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb"); con.Open(); adapt = new OleDbDataAdapter(source, con); ds.Tables.Add(); adapt.Fill(ds.Tables[1]); con.Close(); CrystalReport3 rep = new CrystalReport3(); rep.Database.Tables[0].SetDataSource(ds.Tables[0]); rep.Database.Tables[1].SetDataSource(ds.Tables[1]); crystalReportViewer1.ReportSource = rep; crystalReportViewer1.Refresh(); } else if (comboBox1.Text == "Average Per Year") { PictureLoad(); calendar1.OnlyMonthMode = false; calendar1.SetViewMode(MonthCalendar.ViewMode.vm12Years, MonthCalendar.ViewMode.vmYear); calendar1.SetViewMode(MonthCalendar.ViewMode.vm12Years, MonthCalendar.ViewMode.vm12Years); calendar1.SetViewMode(MonthCalendar.ViewMode.vm12Years, MonthCalendar.ViewMode.vm120Years); string source = "SELECT Sys, Dias, Year, Stat From YearTable Where PatientID ='" + MainForm.patientID + "' and Year BETWEEN " + calendar1.year1 + " and " + calendar1.year12; OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb"); con.Open(); OleDbDataAdapter adapt = new OleDbDataAdapter(source, con); DataSet ds = new DataSet(); ds.Tables.Add(); adapt.Fill(ds.Tables[0]); con.Close(); source = "SELECT * from Profile WHERE PatientID ='" + MainForm.patientID + "'"; con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb"); con.Open(); adapt = new OleDbDataAdapter(source, con); ds.Tables.Add(); adapt.Fill(ds.Tables[1]); con.Close(); CrystalReport4 rep = new CrystalReport4(); rep.Database.Tables[0].SetDataSource(ds.Tables[0]); rep.Database.Tables[1].SetDataSource(ds.Tables[1]); crystalReportViewer1.ReportSource = rep; crystalReportViewer1.Refresh(); } } catch (Exception) { MessageBox.Show("Invalid operation has been detected!"); Application.Exit(); } }