I have a report with 3 parameters. I want to send the values of the parameters to the report. I am having problems when trying to send values that start with 0. Even if I create the parameter as a string, the leading 0 is cut-off. Similarly, I'm having problems with dates. I can not send '/' or '-'. If I do, the value isn't recognized and I'm prompted to enter it. Any ideas why this is happening and how to get around it?
Some of the code:
EnterpriseSession enterpriseSession = (EnterpriseSession)Session["EnterpriseSession"];
InfoStore infoStore = (InfoStore)Session["InfoStore"];
string rptname = "Aged A/R and WIP Intranet - by Client"; ;
string queryString = "Select SI_ID From CI_INFOOBJECTS WHERE SI_KIND='CrystalReport' "
+ " AND SI_NAME Like '" + rptname + "'";
InfoObjects infoObjectS = infoStore.Query(queryString);
InfoObject infoObject = infoObjectS[1]; //it is 1 based not 0 based.
Report report = (Report)infoObject;
//Setting Parms
ParameterFields paramFields;
ParameterField paramField;
ParameterDiscreteValue discValue;
ParameterValues paramValues;
paramFields = new ParameterFields();
paramField = new ParameterField();
discValue = new ParameterDiscreteValue();
paramValues = new ParameterValues();
paramField.Name = "@Client_Code";
discValue.Value = "00280";
discValue.IsRange = false;
paramValues.Add(discValue);
paramField.CurrentValues = paramValues;
paramFields.Add(paramField);
paramField = new ParameterField();
discValue = new ParameterDiscreteValue();
paramValues = new ParameterValues();
paramField.Name = "@Period";
discValue.Value = RPeriod;
discValue.IsRange = false;
paramValues.Add(discValue);
paramField.CurrentValues = paramValues;
paramFields.Add(paramField);
paramField = new ParameterField();
discValue = new ParameterDiscreteValue();
paramValues = new ParameterValues();
paramField.Name = "@EndDate";
discValue.Value = "11/30/2009";
discValue.IsRange = false;
paramValues.Add(discValue);
paramField.CurrentValues = paramValues;
paramFields.Add(paramField);
CrystalReportViewer1.ParameterFieldInfo = paramFields;
//Viewing the report from Enterprise.
CrystalReportViewer1.EnterpriseLogon = enterpriseSession;
CrystalReportViewer1.ReportSource = report;