data reports with stored procs

Question

User-2139767974 posted

is it possible to create datareports (not crystal reports) using stored procs with parameters..

Answer 1

User-519136805 posted

yes ,

sample code : http://www.pdssoftware.com/newsletter/mar07/page6.htm

Hope this will helps !!!

Answer 2

User-2139767974 posted

sandy i am not talking of crystal reports .. i wana know if datareports inculded in the visual studio can support stored procs wiht parameters..

Answer 3

User1471008070 posted

Hi,

If I understand you correctly, you are creating local report(.RDLC) in web application. Actually, we could utilize the Store procedure to retrieve the datasource for the local report. You should return the correct dataset via ADO.NET. Please refer to this link to get a reference:

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/6c679c17-27a7-4e9b-8c81-c9d5dac00d65/ 

Thanks,
Challen Fu