If you take a look at the end of the Page_Load function, we have called a method ReportParameter(). This method will actually add/send the parameters to our report.
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["aaa"]);
Class1 dbc = new Class1();
protected void Page_Load(object sender, EventArgs e)
{
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.ServerName = "nic";
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.UserID = "sa";
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.Password = "sa";
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.DatabaseName = "abcde";
ReportParameter();
}
private void ReportParameter()
{
CrystalReportViewer1.RefreshReport();
ParameterFields paramFields = new ParameterFields();
ParameterField pfItemYr = new ParameterField();
pfItemYr.ParameterFieldName = "year"; //year is Crystal Report Parameter name.
ParameterDiscreteValue dcItemYr = new ParameterDiscreteValue();
dcItemYr.Value = DropDownList1.SelectedValue;
pfItemYr.CurrentValues.Add(dcItemYr);
paramFields.Add(pfItemYr);
CrystalReportViewer1.ParameterFieldInfo = paramFields;
}
}
johnson JeevanPosted Mar 31, 2014, 3:13 AM
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-integer-parameter.htm
jacquelin fernandezPosted Jun 22, 2012, 6:59 AM
how to pass tablename as parametre into crystal report querry can anybody answer me
Irfan LateefPosted Oct 16, 2008, 3:24 AM
When I have placed this code I got this exception "Object reference not set to an instance of an object." please tell me the solution of this problem because it is my urgent task, I don't have idea where i doing mistak.. you can email me at : [email protected] .. please help me.. Thanks in advance
Irfan LateefPosted Oct 16, 2008, 3:19 AM
protected void Page_Load(object sender, EventArgs e) { CrystalDecisions.Shared.ConnectionInfo myConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo(); myConnectionInfo.ServerName = ConfigurationManager.AppSettings["dtServerName"]; myConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["dtName"]; myConnectionInfo.UserID = ConfigurationManager.AppSettings["dtUser"]; myConnectionInfo.Password = ConfigurationManager.AppSettings["dtPwd"]; ReportParameter(); } private void ReportParameter() { CrystalReportViewer1.RefreshReport(); ParameterFields paramFields = new ParameterFields(); ParameterField pfItemYr = new ParameterField(); pfItemYr.ParameterFieldName = "FormNo"; ParameterDiscreteValue dcItemYr = new ParameterDiscreteValue(); dcItemYr.Value = Request.QueryString["formno"].ToString(); pfItemYr.CurrentValues.Add(dcItemYr); paramFields.Add(pfItemYr); CrystalReportViewer1.ParameterFieldInfo = paramFields; }