Report Runs in Report Builder But Not in CRM RRS feed

  • Question

  • I have a report that runs in BIDS and Report Builder but throws the error "The report cannot be displayed" when run from the Report Area of CRM 4.0. It is pre-filtered and is a modified Wizard report. I have stripped out all the extra parameters, so that it now has only two parameters. What could be causing this behavior?
    Wednesday, September 28, 2016 6:36 PM

All replies

  • If you enable tracing, and also check the reporting services logs, you should get more information on the problem

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Wednesday, September 28, 2016 6:48 PM
  • Hi,

    Reports that are manipulated in report builder to use SQL and not fetch xml require that the datasource be set to "embedded" in your report. The datasource connection would need to target the SQL Server you are looking to use.

    Otherwise the report runner is trying to connect to the native CRM datasource which may not work.



    Monday, October 17, 2016 12:28 PM