public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { cryRepInventoryIn rpt = new cryRepInventoryIn(); rpt.Site = this.Site; return(rpt); }
private void btnPrint_Click(object sender, EventArgs e) { if (txtPkid.Text == "") { glb_function.MsgBox("الرجاء اختيار الأمر"); return; } string strTitel = ""; if (strStackadj_type == "امر توريد") { strTitel = "أمر توريد مخزني"; } else { strTitel = "أمر صرف مخزني"; } cryRepInventoryIn report = new cryRepInventoryIn(); frmReportContainer frm = new frmReportContainer(); DataTable dtReport = new DataTable(); TextObject txtCurrency = (TextObject)report.ReportDefinition.ReportObjects["txtReportTitel"]; txtCurrency.Text = strTitel; ConnectionToMySQL cnn = new ConnectionToMySQL(); dtReport = cnn.GetDataTable("SELECT h.pkid,h.stockadj_no,h.warehosue_id,h.stackadj_note,date_format(h.created_date,'%d/%m/%Y') created_date, " + " d.pkid dpkid, d.itemid, d.qty, " + " i.itemno, i.itemname, i.UnitSellingPrice, i.unitCost, " + " a.pkid acc_id, a.Acc_no, a.acc_name, " + " w.warehouse_name " + " FROM stockadjust_header h " + " join stockadjust_details d on(h.pkid = d.header_id) " + " join items i on(d.itemid = i.pkid) " + " join accounts a on(a.pkid = h.acc_id) " + " join warehouse w on(w.pkid = h.warehosue_id) " + " and h.pkid = " + txtPkid.Text); report.SetDataSource(dtReport); frm.CrystalReportsViewer1.ReportSource = report; frm.ShowDialog(); }