public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { SupplierOrderReport rpt = new SupplierOrderReport(); rpt.Site = this.Site; return(rpt); }
private void SupplierOrderReport_Load(object sender, EventArgs e) { SupplierOrderReport sp = new SupplierOrderReport(); if (dB.IsConnect()) { var dkt = DateTime.Now; DateTime dates = DateTime.Now; var fd = new DateTime(dates.Year, dates.Month, 1); var ld = fd.AddMonths(1).AddDays(-1); string query = " SELECT supplier_order1.supplier_order_id, supplier_order1.supplier_order_date_placed, product1.product_name, supplier1.supplier_name, supplier_order1.supplier_order_number, supplier_order_line1.supplier_order_line_quantity FROM((golden_connect.supplier_order_line supplier_order_line1 INNER JOIN golden_connect.supplier_order supplier_order1 ON supplier_order_line1.supplier_order_id = supplier_order1.supplier_order_id) INNER JOIN golden_connect.product product1 ON supplier_order_line1.product_id = product1.product_id) INNER JOIN golden_connect.supplier supplier1 ON supplier_order1.supplier_id = supplier1.supplier_id"; var adapt = new MySqlDataAdapter(query, dB.Connection); DataSet dt = new DataSet(); adapt.Fill(dt, "supplier_order"); sp.SetDataSource(dt); supplierOrderRep.ReportSource = sp; supplierOrderRep.Refresh(); } }