Missing Parameter values in Crystal reports

[chamarajanaka]

When i run the page i'm getting a message showing."Missing Parameter values" and want display the report. i've used following formula

Year ({tbl_DisasterRegistration.Date})  =  Year (CurrentDate)  - {?@YearCount}

By right click on the report...Report->Selection Formula->Record

my code is used in DropDownList1_SelectedIndexChanged

ReportDocument crystalReport = new ReportDocument();
            crystalReport.Load(Server.MapPath(@"/Presentation Layer/Reports/YearlyStatistics.rpt"));
            crystalReport.SetDatabaseLogon("", "", "XPWINDOWS7\\SQLEXPRESS", "PODRAS_MS");
            ParameterFieldDefinitions crParameterFieldDefinitions;
            ParameterFieldDefinition crParameterFieldDefinition;
 
            ParameterValues crParameterValues = new ParameterValues();
            ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
 
 
            crParameterDiscreteValue.Value = Convert.ToInt32(DropDownList1.SelectedItem.Value);
            crParameterFieldDefinitions = crystalReport.DataDefinition.ParameterFields;
            crParameterFieldDefinition = crParameterFieldDefinitions["@YearCount"];
            crParameterValues = crParameterFieldDefinition.CurrentValues;
 
            crParameterValues.Clear();
            crParameterValues.Add(crParameterDiscreteValue);
            crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
 
            CrystalReportViewer1.ReportSource = crystalReport;
            CrystalReportViewer1.RefreshReport();

i also tried this on page load event by giving

crParameterDiscreteValue.Value =1

same error occurs???

can anyone help???

[Jyoti Ballabh]

maybe, you need to reset the parameter as follows-

ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();
ParameterRangeValue rangeVal = new ParameterRangeValue();
ParameterValues curvalues = new ParameterValues();
foreach (ParameterFieldDefinition parafld in 
             crReport.DataDefinition.ParameterFields)
{
  if (parafld.DiscreteOrRangeKind.ToString() == "DiscreteValue")
  {
    discreteVal.Value =
 
           Request.QueryString[parafld.ParameterFieldName];
    if (discreteVal.Value != null)
    {
      curvalues.Add(discreteVal);
      parafld.ApplyCurrentValues(curvalues);
    }
  }
 
}

[cr4sh]

your approach to the whole problem is great. have a look at the parameter sequencing in the code below.....

Dim objReport As New CrystalDecisions.CrystalReports.Engine.ReportDocument
Dim ConInfo As New CrystalDecisions.Shared.TableLogOnInfo
Dim paraValue As New CrystalDecisions.Shared.ParameterDiscreteValue
Dim currValue As CrystalDecisions.Shared.ParameterValues
Dim sParValPair() As String
Dim sValue() As String
Dim iIndex As Integer
Dim crFieldDef As CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinitions
Dim crFieldLoc As CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition
ConInfo.ConnectionInfo.ServerName = modLibrary.m_sDATASOURCE
ConInfo.ConnectionInfo.DatabaseName = modLibrary.m_sDATABASE
ConInfo.ConnectionInfo.IntegratedSecurity = True
objReport.Database.Tables(intCounter).ApplyLogOnInfo(ConInfo)
crFieldDef = objReport.DataDefinition.ParameterFields
sParValPair = sParam.Split(";")
For iIndex = 0 To UBound(sParValPair)
   If InStr(sParValPair(iIndex), "=") > 0 Then
      sValue = sParValPair(iIndex).Split("=")
      crFieldLoc = crFieldDef.Item(sValue(0))
      currValue = crFieldLoc.CurrentValues
      paraValue.Value = sValue(1)
      currValue.Add(paraValue)
      crFieldLoc.ApplyCurrentValues(currValue)
   End If
Next iIndex

[chamarajanaka]

Thanks for the replies problem was resolved by removing

CrystalReportViewer1.RefreshReport();