public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { StaetementOfOneAccountCrystalReportAll rpt = new StaetementOfOneAccountCrystalReportAll(); rpt.Site = this.Site; return(rpt); }
private void button1_Click(object sender, EventArgs e) { //creating an object of ParameterField class ParameterField paramField = new ParameterField(); //creating an object of ParameterFields class ParameterFields paramFields = new ParameterFields(); //creating an object of ParameterDiscreteValue class ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue(); //set the parameter field name paramField.Name = "account no"; //set the parameter value paramDiscreteValue.Value = accountNoComboBox.Text; //add the parameter value in the ParameterField object paramField.CurrentValues.Add(paramDiscreteValue); //add the parameter in the ParameterFields object paramFields.Add(paramField); //set the parameterfield information in the crystal report ReportViewer f2 = new ReportViewer(); TableLogOnInfos reportLogonInfos = new TableLogOnInfos(); TableLogOnInfo reportLogonInfo = new TableLogOnInfo(); ConnectionInfo reportConInfo = new ConnectionInfo(); Tables tables = default(Tables); // Table table = default(Table); var with1 = reportConInfo; with1.ServerName = "LAPTOP-19NF5E9"; with1.DatabaseName = "BankReconciliationDBProNovember"; with1.UserID = "sa"; with1.Password = "******"; StaetementOfOneAccountCrystalReportAll cr = new StaetementOfOneAccountCrystalReportAll(); tables = cr.Database.Tables; foreach (Table table in tables) { reportLogonInfo = table.LogOnInfo; reportLogonInfo.ConnectionInfo = reportConInfo; table.ApplyLogOnInfo(reportLogonInfo); } f2.crystalReportViewer1.ParameterFieldInfo = paramFields; //set the parameterfield information in the crystal report f2.crystalReportViewer1.ReportSource = cr; this.Visible = false; f2.ShowDialog(); this.Visible = true; }