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