Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
How to user storeprocedure for running reports in mscrm-2011 from separate databse

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

  • Thursday, July 12, 2012 1:49 PM
     
     
    Sign In to Vote
    0

    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


     

All Replies

  • Thursday, July 12, 2012 3:23 PM
    Answerer
     
     
    Sign In to Vote
    0

    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"