private void generate_purchase_report_Load(object sender, EventArgs e) { if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); DataSet3 ds = new DataSet3(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = j; cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds.DataTable1); da.Fill(dt); tot = 0; foreach (DataRow dr in dt.Rows) { tot += Convert.ToInt32(dr["product_total"].ToString()); } CrystalReport3 myreport = new CrystalReport3(); myreport.SetDataSource(ds); myreport.SetParameterValue("total", tot.ToString()); crystalReportViewer1.ReportSource = myreport; }
private void Form14_Load(object sender, EventArgs e) { CrystalReport3 rapor = new CrystalReport3(); CrystalDecisions.Shared.ParameterValues parametre = new CrystalDecisions.Shared.ParameterValues(); CrystalDecisions.Shared.ParameterDiscreteValue deger = new CrystalDecisions.Shared.ParameterDiscreteValue(); deger.Value = Form12.kodx; parametre.Add(deger); rapor.DataDefinition.ParameterFields["tcno"].ApplyCurrentValues(parametre); crystalReportViewer1.ReportSource = rapor; }
private void button3_Click(object sender, EventArgs e) { CrystalReport3 cr = new CrystalReport3(); SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnStringDb1"].ConnectionString; string sql = "select * from QR WHERE ID =" + 3; DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter(sql, con); ad.Fill(ds, "Table1"); cr.SetDataSource(ds.Tables["Table1"]); crystalReportViewer1.ReportSource = cr; crystalReportViewer1.Refresh(); }
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(); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReport3 rpt = new CrystalReport3(); rpt.Site = this.Site; return rpt; }
private void button9_Click(object sender, EventArgs e) { string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source=Kyrsovaya.mdb"; OleDbConnection connection = new OleDbConnection(); connection.ConnectionString = ConnectionString; OleDbCommand myCommand; string sq1; sq1 = "SELECT * FROM Клиенты"; myCommand = new OleDbCommand(sq1, connection); connection.Open(); OleDbDataAdapter da = new OleDbDataAdapter(myCommand); DataSet ds = new DataSet(); da.Fill(ds, "Результат"); ds.WriteXmlSchema("schema3.xml"); CrystalReport3 rpt = new CrystalReport3(); rpt.SetDataSource(ds); crystalReportViewer3.ReportSource = rpt; connection.Close(); }