vbnetcoder
asked on
passing parameter to stored procedure error - procedure of function 'spStoreProcedure' expects parameter @ActorID which was not supplied
I have a stored procedure which has a parameter actor id. I am trying to pass it a parameter from my report in the filter of the dataset that i am using for my report data. What am i doing wrong? See screenshots
Error.JPG
Dataset-Filter.JPG
Error.JPG
Dataset-Filter.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you sure the data types are matching? What type is your report parameter (prActorNames)? Also, can you post the SP definition?
ASKER
ty