FIM2003
asked on
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:
However, I am receiving the error:
System.Runtime.InteropServ ices.COMEx ception: 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.
?@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");
However, I am receiving the error:
System.Runtime.InteropServ
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.