MS CRM 4.0 Report Deployement RRS feed

  • Question

  • Hi,

    I have built few SSRS Report for CRM Reporting puropse.I deployed these SSRS Report to Report Manager.It is working fine.

    My issue is when I deployed these .RDL extension file using MS CRM Report Builder Tool,it shows me Error.

    Tuesday, September 28, 2010 10:55 AM

All replies

  • can you please check whether the existing reports of CRM are working or not?



    Tuesday, September 28, 2010 11:02 AM
  • What error message r u getting?
    Microsoft Certified Business Management Solutions Specialist
    Wednesday, September 29, 2010 3:57 AM
  • Hi,

    You can trace the exact error which is getting throw.

    For Error Description in Error Log:
    Log on to SQL Server, go to installation folder of SQL Server Reporting Services. Open the latest log file and see the error description.
    EG: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles

    Regarding Deployment:
    Do not use Shared Data Source, When you test it from SSRS, use the Report connectionstring.
    And When you deply the report to MS CRM, MS CRM automatically assign the Data Source to the REPORTS [according to your Organisation].

    There are plenty of approaches to deploying a report onto CRM.

    1. Once the RDL file is created, use CRM Reports area (Workplace > Reports) and give the path to the RDL file.

    2. You could also deploy the report on the Report Manager, retrieve it's web address and use CRM's reports area and provide the link to the report.

    If you're trying to access the report from on of the client machines, make sure you have the Connector for SQL Server Reporting Services installed. Also the use of localhost in the connection string might be an issue causer. Try using the CRM server name.

    Hope it helps!

    Thanks, Ranjitsingh R | http://mscrm-developer.blogspot.com/ | MS CRM Consultant
    Monday, October 4, 2010 8:45 AM
  • Amitabh,

    Report Builder Tool support SQL 2008 only so if you're using SQL 2005 for CRM you will be able to run but not deploy report to crm.

    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    Monday, October 4, 2010 11:05 PM
  • Hi,

    Have you tried to deploy your report with PublishReports tool????

    Monday, October 11, 2010 4:20 PM