Skip to Content
0
Former Member
Jan 06, 2010 at 04:00 PM

Problems with parameter value passing using .Net ASP and CRS XI R2

23 Views

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;