Solved

Missing Parameter Values - Passing to Stored Procedure

Posted on 2011-03-16
2
1,047 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:FIM2003
2 Comments
 
LVL 3

Accepted Solution

by:
chrisrbloom earned 250 total points
ID: 35148183
just a thought - make sure the dates are actual dates, and not string values.
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 35149397
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

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question