I am using two parameters in my report. DepartmentID and EmployeeID. The employeeID is cascaded and it expects a DepartmentID as the query parameter in stored proc. The sp works fine in SQL and even from the datasets created in report designer. But when I preview the report and select a department to get the employee list populated, I get the following weirdo error:
An error occured during local report processing
The value provided for the report parameter 'EmployeeID' is not valid for its type.
I have checked and rechecked, and had some one else take a look at the report params, data types, and stored procs, but for the life of it, I can't figure out why I am getting this error? It seems the report designer is goofed up or something. Any ideas?
Never mind,, I resolved it. Somehow the allow blank values was highlighted even though the parameter data type was selected as integer.
No comments:
Post a Comment