Sqlreporting Serives from stored procedure

Posted Date: 08 Oct 2008 Posted By: Kumar Member Level: Gold Points: 1 Responses: 2

Hi all,

i have used stored procedure in that i need to use sqlreporting services to get the data from stored procedure .

is it possible to get the data from stored procedure to sqlreporting service .

Can anyone please send me how can i perform this using sqlreporting services.

Thanx in advance ,

Kumar

Responses

Author: www.DotNetVJ.com 08 Oct 2008

Member Level: Diamond

Rating:

Points: 2

Hi

Check out the below link
http://www.experts-exchange.com/Database/Reporting_/SQR/Q_22410697.html

Thanks -- Vj
http://dotnetvj.blogspot.com
http://oravj.blogspot.com

Thanks -- Vijaya Kadiyala
http://www.DotNetVJ.com
Microsoft MVP
Me & My Little Techie

Author: Vivek 08 Oct 2008

Member Level: Gold

Rating:

Points: 2

Hi,

When you specifiy your dateset you need to specify command type as store procedure and in Query specify your store procedure name.

Refer below URLs.

http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-1/

http://www.15seconds.com/issue/041027.htm

Thanks,
Vivek

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : QUERY- i want to display max3 rd salary with name? how !!!
	Previous : sql 2000
	Return to Discussion Forum
	Post New Message
	Category: SQL Server

Related Messages

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use