private void button6_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtSupCode.Text)) { MessageBox.Show("Type A Valid Supplier"); txtSupCode.Focus(); } else if (!chkAllRoutes.Checked && String.IsNullOrEmpty(mySupplier.getSupplierName(cmbRoute.SelectedValue.ToString(), txtSupCode.Text))) { MessageBox.Show("Type A Valid Supplier"); txtSupCode.Focus(); } else if (chkAllRoutes.Checked && String.IsNullOrEmpty(mySupplier.getSupplierName(txtSupCode.Text))) { MessageBox.Show("Type A Valid Supplier"); txtSupCode.Focus(); } else { DataSet dsRPT = new DataSet(); DataTable dataSetReport1 = new DataTable(); dataSetReport1.TableName = "PaymentsHistory"; string supCode = string.Empty; supCode = txtSupCode.Text; string strRoute = "%"; if (chkAllRoutes.Checked) { strRoute = "%"; } else { strRoute = cmbRoute.SelectedValue.ToString(); } //dataSetReport = myMonthlySummary.getSupplierPaymentsDetail(ToDate.Value.Year, ToDate.Value.Month, supCode, strRoute).Tables[0]; dataSetReport1 = myMonthlySummary.getCreditAvailabilityPaymentSummary(ToDate.Value.Year, ToDate.Value.Month, FromDate.Value.Month, supCode, strRoute).Tables[0]; dataSetReport1.TableName = "History"; if (dataSetReport1.Rows.Count > 0) { //dataSetReport.WriteXml("SupplierPaymentsSummary.xml"); dataSetReport1.WriteXml("supplierPaymentsHistory.xml"); SupplierGLHistoryRPT glRpt = new SupplierGLHistoryRPT(); glRpt.SetDataSource(dataSetReport1); //myReport.SetDataSource(dataSetReport1); ReportViewer rptViewer = new ReportViewer(); rptViewer.crystalReportViewer1.ReportSource = glRpt; rptViewer.Show(); } else { MessageBox.Show("No Data Available"); } } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { SupplierGLHistoryRPT rpt = new SupplierGLHistoryRPT(); rpt.Site = this.Site; return(rpt); }
private void button5_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtSupCode.Text)) { MessageBox.Show("Type A Valid Supplier"); txtSupCode.Focus(); } else if (!chkAllRoutes.Checked && String.IsNullOrEmpty(mySupplier.getSupplierName(cmbRoute.SelectedValue.ToString(), txtSupCode.Text))) { MessageBox.Show("Type A Valid Supplier"); txtSupCode.Focus(); } else if (chkAllRoutes.Checked && String.IsNullOrEmpty(mySupplier.getSupplierName(txtSupCode.Text))) { MessageBox.Show("Type A Valid Supplier"); txtSupCode.Focus(); } else { DataSet dsRPT = new DataSet(); DataTable dataSetReport = new DataTable(); dataSetReport.TableName = "SupplierPaymentsSummary"; DataTable dataSetReport1 = new DataTable(); dataSetReport.TableName = "PaymentsHistory"; string supCode = string.Empty; supCode = txtSupCode.Text; string strRoute = "%"; if (chkAllRoutes.Checked) { strRoute = "%"; } else { strRoute = cmbRoute.SelectedValue.ToString(); } dataSetReport = myMonthlySummary.getSupplierPaymentsDetail(ToDate.Value.Year, ToDate.Value.Month, supCode, strRoute).Tables[0]; dataSetReport1 = myMonthlySummary.getCreditAvailabilityPaymentSummary(ToDate.Value.Year, ToDate.Value.Month, FromDate.Value.Month, supCode, strRoute).Tables[0]; dataSetReport1.TableName = "History"; if (dataSetReport.Rows.Count > 0) { dataSetReport.WriteXml("SupplierPaymentsSummary.xml"); dataSetReport1.WriteXml("supplierPaymentsHistory.xml"); //SupplierCreditAvailabilityRPT myReport = new SupplierCreditAvailabilityRPT(); SupplierCreditAvailabilityRPTTemp myReport = new SupplierCreditAvailabilityRPTTemp(); myReport.SetDataSource(dataSetReport); SupplierGLHistoryRPT glRpt = new SupplierGLHistoryRPT(); glRpt.SetDataSource(dataSetReport1); //myReport.SetDataSource(dataSetReport1); ReportViewer rptViewer = new ReportViewer(); myReport.SetParameterValue("Company", BoughtLeafBusinessLayer.BLUser.getCompanyName()); myReport.SetParameterValue("Year", ToDate.Value.Date.Year.ToString()); myReport.SetParameterValue("Month", ToDate.Value.Date.Month.ToString()); //myReport.SetParameterValue("payRate", mySettings.getKiloRate(ToDate.Value.Date.Year, ToDate.Value.Date.Month)); myReport.SetParameterValue("payRate", Convert.ToDecimal(txt_rate.Text)); rptViewer.crystalReportViewer1.ReportSource = myReport; rptViewer.Show(); } else { MessageBox.Show("No Data Available"); } } }