Passing parameters into Crystal Reports

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hello everyone,
Does anyone know what code should i use in order to pass a parameters into
the Crystal Report's SQL command?
Any web site references is welcomed too!
Thanks
Tony
 
You can use this code as an example
....
public class ParGen
{
public ParameterFields Fields = new ParameterFields();

public ParameterDiscreteValue nombreEmpresa = new
ParameterDiscreteValue();
public ParameterDiscreteValue nombreCentroAct = new
ParameterDiscreteValue();
public ParameterDiscreteValue nombreUsuario = new
ParameterDiscreteValue();

public ParGen()
{
ParameterField paramField1 = new ParameterField();
paramField1.ParameterFieldName = "nombreEmpresa";
nombreEmpresa.Value = mpsStatic.nombreEmpresa;
paramField1.CurrentValues.Add(nombreEmpresa);
Fields.Add(paramField1);

ParameterField paramField2 = new ParameterField();
paramField2.ParameterFieldName = "nombreCentroAct";
nombreCentroAct.Value = mpsStatic.nombreCentroAct;
paramField2.CurrentValues.Add(nombreCentroAct);
Fields.Add(paramField2);

ParameterField paramField3 = new ParameterField();
paramField3.ParameterFieldName = "nombreUsuario";
nombreUsuario.Value = mpsStatic.nombreUsuario;
paramField3.CurrentValues.Add(nombreUsuario);
Fields.Add(paramField3);
}
}
..
ParGen repParm = new ParGen();
..
crystalReportViewer1.ParameterFieldInfo = repParm.Fields;

I hope this help...
If need more help post a replay...

MP
 
Back
Top