Is there a way to create a report in SQL2005 reporting services to call a stored procedure that has parameters? I keep getting an error saying i am not supplying the params, I can't seem to find where to put my parameters for the report to use.
Thanks,
Joe
How about something like
exec uspTest @.parm1, @.parm2
If I remember right it will provide a couple of boxes for you to type the parm values when you view the report in Report Manager
|||the parameters (Report Parameters) you have in RS should have the same name as the parameters you declare in stored procedure.sql
No comments:
Post a Comment