public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReport1 rpt = new CrystalReport1(); rpt.Site = this.Site; return(rpt); }
private void Form1_Load(object sender, EventArgs e) { #region 水晶报表 CrystalReport1 cr = new CrystalReport1(); var title = cr.Section1.ReportObjects["TextTitle"]; if (title.Kind == ReportObjectKind.TextObject) { ((TextObject)title).Text = "XX一览"; } cr.ParameterFields["type"].CurrentValues.AddValue("这是水晶报表"); crystalReportViewer1.ReportSource = cr; #endregion }
private void crystalReportViewer1_Load(object sender, EventArgs e) { if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); DataSet1 ds = new DataSet1(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "select * from orderUser where id = " + j + ""; cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds.DataTable1); SqlCommand cmd2 = con.CreateCommand(); cmd2.CommandType = CommandType.Text; cmd2.CommandText = "select * from items where order_id = " + j + ""; cmd2.ExecuteNonQuery(); DataTable dt2 = new DataTable(); SqlDataAdapter da2 = new SqlDataAdapter(cmd2); da2.Fill(ds.DataTable2); da2.Fill(dt2); tot = 0; foreach (DataRow dr2 in dt2.Rows) { tot = tot + Convert.ToInt32(dr2["total"].ToString()); } CrystalReport1 myreport = new CrystalReport1(); myreport.SetDataSource(ds); myreport.SetParameterValue("total", tot.ToString()); crystalReportViewer1.ReportSource = myreport; }
private void button1_Click(object sender, EventArgs e) { try { DataSet1 ds = new DataSet1(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "select * from issue_books where books_return_date=''"; cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds.DataTable1); CrystalReport1 myreport = new CrystalReport1(); myreport.SetDataSource(ds); crystalReportViewer1.ReportSource = myreport; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void loadPrint() { if (salescommit == "1") { string q1 = "select itemCode,itemName,quantity,unitPrice,Amount,sReturn from Sales where salesNo='" + sl + "'"; string q2 = "select salesNo,sDate,total,salesType,creditCardPer,discountPer,vatAmount,grandTotal,receive,change from SalesSummary where salesNo='" + sl + "'"; try { aa.Open(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(q1, aa); DataSet1 mydataset = new DataSet1(); da.Fill(mydataset, "Sales"); da.Dispose(); SqlDataAdapter da2 = new SqlDataAdapter(); da2.SelectCommand = new SqlCommand(q2, aa); da2.Fill(mydataset, "SalesSummary"); CrystalReport1 myreport = new CrystalReport1(); myreport.SetDataSource(mydataset); PrintMemo pm = new PrintMemo(); pm.crystalReportViewer1.ReportSource = myreport; pm.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { aa.Close(); } } else { MessageBox.Show("First commit sales by Clicking Save Button!", "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
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(); } }
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("schema.xml"); CrystalReport1 rpt = new CrystalReport1(); rpt.SetDataSource(ds); crystalReportViewer1.ReportSource = rpt; connection.Close(); }
private void loadPrint() { if(commit == "1") { string q1 = "select itemCode,itemName,quantity,unitPrice,Amount,sReturn from Sales where salesNo='" + sl + "'"; string q2 = "select salesNo,sDate,total,salesType,creditCardPer,discountPer,vatAmount,grandTotal,receive,change from SalesSummary where salesNo='" + sl + "'"; try { aa.Open(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(q1, aa); DataSet1 mydataset = new DataSet1(); da.Fill(mydataset, "Sales"); da.Dispose(); SqlDataAdapter da2 = new SqlDataAdapter(); da2.SelectCommand = new SqlCommand(q2, aa); da2.Fill(mydataset, "SalesSummary"); CrystalReport1 myreport = new CrystalReport1(); myreport.SetDataSource(mydataset); PrintMemo pm = new PrintMemo(); pm.crystalReportViewer1.ReportSource = myreport; pm.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { aa.Close(); } } else { MessageBox.Show("First commit sales by Clicking Save Button!", "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReport1 rpt = new CrystalReport1(); rpt.Site = this.Site; return rpt; }