private void saveFileDialog1_FileOk(object sender, CancelEventArgs e) { if (saveFileDialog1.Filter.IndexOf("Word") > 0) { CrystalReport11.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, saveFileDialog1.FileName); } if (saveFileDialog1.Filter.IndexOf("Excel") > 0) { CrystalReport11.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, saveFileDialog1.FileName); } }
public ActionResult GenerateReport6() { DB50Entities db = new DB50Entities(); var c = db.Report11(); CrystalReport11 r = new CrystalReport11(); r.Load(); Stream s = r.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); return(File(s, "application/pdf")); }
private void crystalReportViewer1_Load(object sender, EventArgs e) { try { OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=products.mdb"); OleDbDataAdapter dataAdapter = new OleDbDataAdapter("SELECT ID, ProductName, ProductDescription, ProductPrice FROM Products", connection); // fill dataset DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); connection.Close(); // add virtual column into the result table dataSet.Tables[0].Columns.Add(new DataColumn("BarcodeImage", typeof(byte[]))); // create barcode object Barcode barcode = new Barcode(SymbologyType.Code128); barcode.DrawCaption = false; // Fill BarcodeImage column with generated barcode image bytes foreach (DataRow row in dataSet.Tables[0].Rows) { // set barcode value barcode.Value = Convert.ToString(row["ID"]); // retrieve generated image bytes byte[] barcodeBytes = barcode.GetImageBytesWMF(); // fill virtual column with generated image bytes row["BarcodeImage"] = barcodeBytes; } // set filled DataSet as report's data source CrystalReport11.SetDataSource(dataSet.Tables[0]); } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message); } }
private void Form1_Load(object sender, EventArgs e) { connection = new SqlConnection(@"Data Source=SANG-LAPTOP\SQLEXPRESS;Initial Catalog=QLSINHVIEN4;Integrated Security=True"); dataAdapter = new SqlDataAdapter("SELECT * FROM KHOA", connection); dtKhoa = new DataTable(); dataAdapter.Fill(dtKhoa); dataAdapter.SelectCommand.CommandText = "SELECT SINHVIEN.MaLop, SINHVIEN.NgaySinh, SINHVIEN.HoTen, SINHVIEN.MaSV, LOP.MaLop AS Expr1, KHOA.MaKhoa, KHOA.TenKhoa" + " FROM SINHVIEN INNER JOIN" + " LOP ON SINHVIEN.MaLop = LOP.MaLop INNER JOIN" + " KHOA ON LOP.MaKhoa = KHOA.MaKhoa"; dtSinhVien = new DataTable(); dataAdapter.Fill(dtSinhVien); cbbKhoa.DataSource = dtKhoa; cbbKhoa.DisplayMember = "TenKhoa"; cbbKhoa.ValueMember = "MaKhoa"; cbbKhoa.SelectedIndex = -1; CrystalReport11.SetDataSource(dtSinhVien); crvDSSV.ReportSource = CrystalReport11; }
public Form1() { InitializeComponent(); try { // MODIFY THE CONNECTION STRING WITH YOUR SERVER CONNECTION INFO!!! const string connectionString = "Data Source=localhost\\SQLEXPRESS;Initial Catalog=master;Integrated Security=true;"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); // Create a database for demonstration purposes /////////////////////////////////////////////////////////////////////////////////////// Object o = ExecuteQueryScalar(connection, "SELECT DB_ID('example_db')"); // if 'example_db' does not exist, create it if (o == null || o is DBNull) { // Create empty database ExecuteQueryWithoutResult(connection, "CREATE DATABASE example_db"); // Switch to created database ExecuteQueryWithoutResult(connection, "USE example_db"); // Create a table ExecuteQueryWithoutResult(connection, "CREATE TABLE Products ([Product ID] int, [Product Name] nvarchar(100), [Product Description] nvarchar(255))"); // Fill the table with data ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(1, 'Spreadsheet Tools', 'Convert XLS, XLSX, CSV, ODS spreadsheet into HTML, PDF, XLS, XLSX, CSV formats WITHOUT EXCEL installed')"); ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(2, 'Watermarking PRO', 'Professional tool to protect images: multiple watermarks, custom position for watermarks, image effects, EXIF and IPTC macros for text and more')"); ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(3, 'Watermarking', 'Protect copyrights for your images with professional looking watermarks with this easy to use tool')"); ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(4, 'PPT To Video Scout', 'converts PowerPoint presentations (PPT, PPTX) into AVI,MPEG,WMV, FLV (flash video) video movies with sound')"); } // Create a datataset from query. // Query result columns must conform to field names we used in the report designer SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT [Product ID], [Product Name], [Product Description] FROM example_db.dbo.Products", connection); // fill dataset DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); // don't forget to close the connection connection.Close(); // add virtual column into the result table dataSet.Tables[0].Columns.Add(new DataColumn("BarCode", typeof(byte[]))); // create barcode object Barcode bc = new Barcode(SymbologyType.Code39); bc.DrawCaption = false; foreach (DataRow row in dataSet.Tables[0].Rows) { // set barcode value bc.Value = (Convert.ToString(row["Product ID"])); // retrieve generated image bytes byte[] barcodeBytes = bc.GetImageBytesWMF(); // fill virtual column with generated image bytes row["BarCode"] = barcodeBytes; } // set report datasource CrystalReport11.SetDataSource(dataSet.Tables[0]); } } catch (Exception ex) { Trace.WriteLine("Error: " + ex.Message); } }
private void FrmMain_OnPassTestNumber(string TestNumber) { TestData = TestNumber; string executable = System.Reflection.Assembly.GetExecutingAssembly().Location; string path = (System.IO.Path.GetDirectoryName(executable)); AppDomain.CurrentDomain.SetData("Data Directory", path); dsReport ds = new dsReport(); string test = "SELECT * FROM tblTest WHERE TestNumber = @testnumber"; string excitation = "SELECT * FROM tblExcitation WHERE TestNumber = @testnumber"; string ipf = "SELECT * FROM tblIPF WHERE TestNumber = @testnumber"; string bushing = "SELECT * FROM tblBushing WHERE TestNumber = @testnumber"; string ttr = "SELECT * FROM tblTTR WHERE TestNumber = @testnumber"; string winding = "SELECT * FROM tblWinding WHERE TestNumber = @testnumber"; string dielectric = "SELECT * FROM tblDielectric WHERE TestNumber = @testnumber"; string oilpf = "SELECT * FROM tblOilPF WHERE TestNumber = @testnumber"; try { using (SqlConnection con = new SqlConnection(constring)) { con.Open(); using (SqlCommand cmd = new SqlCommand(test, con)) { cmd.Parameters.AddWithValue("@testnumber", TestData); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds.Tables["Test"]); } } using (SqlCommand cmd = new SqlCommand(excitation, con)) { cmd.Parameters.AddWithValue("@testnumber", TestData); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds.Tables["Excitation"]); } } using (SqlCommand cmd = new SqlCommand(ipf, con)) { cmd.Parameters.AddWithValue("@testnumber", TestData); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds.Tables["IPF"]); } } using (SqlCommand cmd = new SqlCommand(bushing, con)) { cmd.Parameters.AddWithValue("@testnumber", TestData); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds.Tables["Bushing"]); } } using (SqlCommand cmd = new SqlCommand(ttr, con)) { cmd.Parameters.AddWithValue("@testnumber", TestData); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds.Tables["TTR"]); } } using (SqlCommand cmd = new SqlCommand(winding, con)) { cmd.Parameters.AddWithValue("@testnumber", TestData); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds.Tables["Winding"]); } } using (SqlCommand cmd = new SqlCommand(dielectric, con)) { cmd.Parameters.AddWithValue("@testnumber", TestData); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds.Tables["Dielectric"]); } } using (SqlCommand cmd = new SqlCommand(oilpf, con)) { cmd.Parameters.AddWithValue("@testnumber", TestData); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds.Tables["OilPF"]); } } con.Close(); } CrystalReport11.SetDataSource(ds); crystalReportViewer1.ReportSource = CrystalReport11; crystalReportViewer1.Refresh(); } finally { frmMain.OnPassTestNumber -= FrmMain_OnPassTestNumber; } }
public CReport(IQueryable shkafs) { InitializeComponent(); CrystalReport11.SetDataSource(shkafs); //CrystalReport11.SetDataSource(DataBaseAccess.db.Shkafs); }
private void btnXuatReport_Click(object sender, EventArgs e) { dtSinhVien.DefaultView.RowFilter = "MaKhoa= '" + cbbKhoa.SelectedValue.ToString() + "'"; CrystalReport11.SetDataSource(dtSinhVien.DefaultView); crvDSSV.ReportSource = CrystalReport11; }