Missing Parameter Values - Passing to Stored Procedure

I have a report databinded via a stored procedure. I am needing to send an id, begin date and end date. The parameters that the stored procedure has are:

?@id
?@begdate
?@enddate


The report also has several subreports that are each databinded with the stored procedure and then are linked by ?@id.


I am trying to send it via the following code:

report.SetParameterValue("@id", id);
report.SetParameterValue("@begdate", begDateCR);
report.SetParameterValue("@enddate", endDateCR);
 
report.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, false, "statement");

Open in new window



However, I am receiving the error:

System.Runtime.InteropServices.COMException: Missing parameter values.

The report looks good and works when I run it within the "Main Report Preview" window and set the values, however, the error at runtime.
FIM2003Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
chrisrbloomConnect With a Mentor Commented:
just a thought - make sure the dates are actual dates, and not string values.
0
 
mlmccConnect With a Mentor Commented:
If you change the FALSE to TRUE do you get prompted for parameters?

Are you linking the subreports using the @id parameter from the main report?
Try linking on the actually main report id field.

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.