private void btnSearch_Click(object sender, EventArgs e) { string ConnectionString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString; using (SqlConnection sqlCon = new SqlConnection(ConnectionString)) try { DailyTransactionRpt reportDocument = new DailyTransactionRpt(); ParameterField paramField = new ParameterField(); ParameterFields paramFields = new ParameterFields(); ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue(); paramField.Name = "@BcDate"; paramField.Name = "@DueDate"; paramDiscreteValue.Value = dtpfromdate.Text; paramDiscreteValue.Value = dtpTodate.Text; paramField.CurrentValues.Add(paramDiscreteValue); paramFields.Add(paramField); paramFields.Add(paramField); crystalReportViewer1.ParameterFieldInfo = paramFields; //string reportPath = Server.MapPath("~/Memberwisrrptfile.rpt"); reportDocument.Load("~/DailyTransactionRpt.rpt"); //reportDocument.Load(@"D:\New folder\Loanapp11sep\10092015 Loan\Loan-25-07-2015\source\LoanApplication\LoanApplication\Memberwisrrptfile.rpt"); reportDocument.SetParameterValue("@BcDate", dtpfromdate.Text); reportDocument.SetParameterValue("@DueDate", dtpTodate.Text); crystalReportViewer1.ReportSource = reportDocument; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { DailyTransactionRpt rpt = new DailyTransactionRpt(); rpt.Site = this.Site; return rpt; }