public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { cryRepItemTrans rpt = new cryRepItemTrans(); rpt.Site = this.Site; return(rpt); }
private void btnPrint_Click(object sender, EventArgs e) { if (lstWarehouses.SelectedIndex == -1) { glb_function.MsgBox("الرجاء اختيار المخزن"); lstWarehouses.Focus(); return; } if (lstItems.SelectedIndex == -1) { glb_function.MsgBox("الرجاء اختيار الصنف"); lstItems.Focus(); return; } cryRepItemTrans report = new cryRepItemTrans(); frmReportContainer frm = new frmReportContainer(); DataTable dtReport = new DataTable(); ConnectionToMySQL cnn = new ConnectionToMySQL(); dtReport.Clear(); dtReport = cnn.GetDataTable("SELECT pkid,date_format(trans_date,'%d/%m/%Y') created_date, " + " trans_name, trans_no, qty, 0 Balance " + " FROM item_trans " + " where warehouse_id = " + lstWarehouses.SelectedValue.ToString() + " and item_id =" + lstItems.SelectedValue.ToString() + " order by trans_date"); double dBalance = 0; for (int i = 0; i < dtReport.Rows.Count; i++) { dtReport.Rows[i]["Balance"] = Convert.ToDouble(dtReport.Rows[i]["qty"].ToString()) + dBalance; dBalance = Convert.ToDouble(dtReport.Rows[i]["Balance"].ToString()); } report.SetDataSource(dtReport); report.SetParameterValue("From", lstWarehouses.Text); report.SetParameterValue("To", lstItems.Text); frm.CrystalReportsViewer1.ReportSource = report; frm.ShowDialog(); }