locked
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.

    Prajwal


    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.

    hth,

    Scott


    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
    Answerer