milfer35
Posts: 1
|
| Posted: 01/30/2007, 8:56 AM |
|
hi i'm new with codecharge and crystal reports 10
i've been trying to send a date parameter to that crystal reports 10 file but it asks me again for the date value but with the text area blocked and empty.
i have a aspx file with a cs file that runs the report file
in the cs file i have this code
CrystalDecisions.Shared.TableLogOnInfo logOnInfo = new CrystalDecisions.Shared.TableLogOnInfo();
CrystalDecisions.Shared.ParameterFields paramFields = new CrystalDecisions.Shared.ParameterFields();
CrystalDecisions.Shared.ParameterField paramField = new CrystalDecisions.Shared.ParameterField();
CrystalDecisions.Shared.ParameterDiscreteValue discreteVal = new CrystalDecisions.Shared.ParameterDiscreteValue();
System.Web.HttpRequest Req = System.Web.HttpContext.Current.Request;
logOnInfo.ConnectionInfo.ServerName = "SERVER INSTANCE";
logOnInfo.ConnectionInfo.DatabaseName = "SERVER";
logOnInfo.ConnectionInfo.UserID = "USER";
logOnInfo.ConnectionInfo.Password = "PASSWORD";
CrystalReportViewer1.LogOnInfo.Add(logOnInfo);
CrystalReportViewer1.ReportSource = "Report file address";
paramField.ParameterFieldName = "Nivel"; //parameter name of the report file.
discreteVal.Value = Req.QueryString["Nivel"]; //link parameter name.
paramField.CurrentValues.Add(discreteVal);
paramFields.Add (paramField);
paramField = new CrystalDecisions.Shared.ParameterField();
discreteVal = new CrystalDecisions.Shared.ParameterDiscreteValue();
paramField.ParameterFieldName = "Muestra Registro";//parameter name of the report file.
discreteVal.Value = Req.QueryString["Registro"];
paramField.CurrentValues.Add(discreteVal);
paramFields.Add (paramField);
paramField = new CrystalDecisions.Shared.ParameterField();
discreteVal = new CrystalDecisions.Shared.ParameterDiscreteValue();
paramField.ParameterFieldName = "@Empresa";//parameter name of the report file.
discreteVal.Value = Req.QueryString["GLB_EMP_Id"];
paramField.CurrentValues.Add(discreteVal);
paramFields.Add (paramField);
paramField = new CrystalDecisions.Shared.ParameterField();
discreteVal = new CrystalDecisions.Shared.ParameterDiscreteValue();
paramField.ParameterFieldName = "@Fecha";//parameter name of the report file.
discreteVal.Value = Req.QueryString["Fecha_Inicial"];
paramField.CurrentValues.Add(discreteVal);
paramFields.Add (paramField);
paramField = new CrystalDecisions.Shared.ParameterField();
discreteVal = new CrystalDecisions.Shared.ParameterDiscreteValue();
paramField.ParameterFieldName = "@FechaF";//parameter name of the report file.
discreteVal.Value = Req.QueryString["Fecha_Final"];
paramField.CurrentValues.Add(discreteVal);
paramFields.Add (paramField);
CrystalReportViewer1.ParameterFieldInfo = paramFields;
this code its very usefull to run report with parameters but it has the problem with dates.
thoes same one can help me with this issue please.
thanks.
_________________
I Love to Learn, and to teach if i know what it's been need to learn. |
 |
 |
|
