locked
data reports with stored procs RRS feed

  • Question

  • User-2139767974 posted

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

    Friday, December 31, 2010 1:51 PM

Answers

All replies

  • User-519136805 posted

    yes ,

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

    Hope this will helps !!!


    Saturday, January 1, 2011 1:37 AM
  • 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..

    Saturday, January 1, 2011 6:00 AM
  • 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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, January 3, 2011 4:09 AM