I need help designing a report that will pull data from a stored procedure based on some parameters. The report works fine when the paramaters are just free-form input fields, but when I try to make the paramaters dynamic, I receive an error on trying to preview the report or upload it to CRS.
The designer gives me the following error when I try to preview the report:
Prompting failed with the following error message: ''.
Error source: Error code: 0x80070057
(the error message is an empty string)
InfoView gives me the following error when I try to upload the report:
Failed to read data from report file C:\WINDOWS\TEMP\SP Activity Report Files.rpt. Reason: Failed to read parameter object
What I currently have is the following:
A stored procedure on the SQL Server 2005 database
create procedure activity_report @report_start_date datetime, @report_end_date datetime, @customer bigint, @contractor bigint, @report_type int, as ...
In my report's database expert, I have the stored procedure, and one other table (CUSTOMER) that contains the values I need to prompt with. No links are set up between the tables. No fields from CUSTOMER are used in the report, only fields from the SP.
Under the "Edit Paramater" dialog for @customer, I have it set up as Dynamic, pulling the Value from CUSTOMER.ID and the description from CUSTOMER.NAME (though it still fails even if I don't use a description).
Can anyone tell me what I'm doing wrong, or what the right way to do this is?
Edited by: Fabio Beltramini on Mar 17, 2009 8:23 PM - Corrected typo in title