How to pass a Report Parameter using C# in Web Application.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • britzer
    New Member
    • Nov 2011
    • 1

    How to pass a Report Parameter using C# in Web Application.

    I tried all the possible combination of codes, and spending almost half of the day searching over the internet but it doesn't work everything, i need help.

    Code 1:

    Code:
    string sFrom = Request.QueryString["From"].ToString()  +" 00:00:00";
            string sTo = Request.QueryString["To"].ToString() +" 23:59:59";
    
            ReportDocument cryRpt = SalesPrRegion.ReportDocument;
    
              
            cryRpt.SetParameterValue(0, Convert.ToDateTime(sTo));
            cryRpt.SetParameterValue(1, Convert.ToDateTime(sFrom));
            cryRpt.SetDatabaseLogon("sa", "sa"); 
            
            CrystalReportViewer1.ReportSource = cryRpt;
            
               
            CrystalReportViewer1.RefreshReport();

    Code 2:

    Code:
    string sFrom = Request.QueryString["From"].ToString()  +" 00:00:00";
            string sTo = Request.QueryString["To"].ToString(); // +" 23:59:59";
             
            ReportDocument cryRpt = new ReportDocument();
                cryRpt.Load(Server.MapPath("SalesPrRegion.rpt"));
    
                ParameterFieldDefinitions crParameterFieldDefinitions ;
                ParameterFieldDefinition crParameterFieldDefinition ;
                ParameterValues crParameterValues = new ParameterValues();
                ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
    
                crParameterDiscreteValue.Value = Convert.ToDateTime(sFrom);
                crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
                crParameterFieldDefinition = crParameterFieldDefinitions[0];
                crParameterValues = crParameterFieldDefinition.CurrentValues;
    
                crParameterValues.Clear();
                crParameterValues.Add(crParameterDiscreteValue);
                crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
    
                crParameterDiscreteValue.Value = Convert.ToDateTime(sTo);
                crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
                crParameterFieldDefinition = crParameterFieldDefinitions[1];
                crParameterValues = crParameterFieldDefinition.CurrentValues;
    
                crParameterValues.Clear();
                crParameterValues.Add(crParameterDiscreteValue);
                crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
    
                cryRpt.SetDatabaseLogon("sa", "sa"); 
                CrystalReportViewer1.ReportSource = cryRpt;
            
               
            CrystalReportViewer1.RefreshReport();
Working...