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 2:
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();