Hi I have created very simple SP like this create procedure Emp_name @state varchar(100) as select * from dbo.emp where state like @state Go How can I use this SP in the Reporting service 2005

Hi Aminesh Suppose you had created your SP in AdventureWork Database. Please see the below image for more idea. You just need to check the Query type option as Stored Procedure. Then what ever database connection you given it will automatically pick up the SP from that database. Suhas | MCP | MCTS Mark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful.

yes subash I already did it and in case of of parameter procedure you just need pass parameter and that will work