pass parameters to stored procedure from crystal reports designer

how to pass parameters to stored procedure from crystal reports de开发者_如何学JAVAsigner and in code also ??

If you use required stored procedure as source for report, while building report itself, you can pass stored procedure parameters from code as the following;

ReportDocument rptDocument = new ReportDocument();

// Load report.
rptDocument.Load(Server.MapPath("rptFileNameOrPath"));

ParameterFields parameterFields = new ParameterFields();
ParameterField parameterField = null;
ParameterDiscreteValue parameterValue = null;

parameterField = new ParameterField();
parameterValue = new ParameterDiscreteValue();
parameterField.Name = "@ContactId";
parameterValue.Value = "1";
parameterField.CurrentValues.Add(parameterValue);
parameterFields.Add(parameterField);
this.rptDocument.SetParameterValue("@ContactId", parameterValue);

@ContactId: is a parameter for required stored procedure.

Finally, you can either export report or print it based on your requirements.

// 0, 0: to print all the pages.
this.rptDocument.PrintToPrinter(1, false, 0, 0);

Regarding Crystal Report Designer, you just use View Report option, you will be asked to enter values for all report parameters, just enter required values.