How to user storeprocedure for running reports in mscrm-2011 from separate databse RRS feed

  • Question

  • I have one report database,  I written query for report as store procedure.
    I am calling storeprocedure in reports. Report will work fine in BIDS but when I deploy same report in MSCRM it is not working.


    Thursday, July 12, 2012 1:49 PM

All replies

  • Can you give us some more information on what error you are getting?

    You will find the Reporting Services Logs somewhere similar to:

    C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

    If you are calling the stored proc from the CRM report - are must make sure that it is callable by the CRM Service account.



    Scott Durow
    Read my blog: www.develop1.net/public
    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    Thursday, July 12, 2012 3:23 PM