using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using System.Data.SqlClient;

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"; //Crystal Report Parameter name
       ParameterDiscreteValue dcItemYr = new ParameterDiscreteValue();
       dcItemYr.Value = DropDownList1.SelectedValue;
       pfItemYr.CurrentValues.Add(dcItemYr);
       paramFields.Add(pfItemYr);
       CrystalReportViewer1.ParameterFieldInfo = paramFields;
   }
}
 or
http://www.dotnetspider.com/kb/Article3477.aspx

Check the following link , it will pass the parameter dynamically to the crystal reports.

http://vb.net-informations.com/cryst...meter_date.htm

yang.

crParameterDiscreteValue.Value = parameterValue;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["paramaterField"];
crParameterValues = crParameterFieldDefinition.CurrentValues;

full source code you can get from here :

http://csharp.net-informations.com/c...-parameter.htm

yang.

ParameterFieldDefinitions crParameterFieldDefinitions ;
ParameterFieldDefinition crParameterFieldDefinition ;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();

crParameterDiscreteValue.Value = paramVal;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["paramField"];
crParameterValues = crParameterFieldDefinition.CurrentValues;

http://csharp.net-informations.com/c...-parameter.htm

yang.

crParameterDiscreteValue.Value = value;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["Field"];
crParameterValues = crParameterFieldDefinition.CurrentValues;

http://csharp.net-informations.com/c...-parameter.htm

lee.