locked
CRM reports giving blank screen RRS feed

  • Question

  • Hello All,

    I am getting blank screen with no data when I run report on my CRM 2011 deployment. I  checked SSRS web interface on the SQL server installation, when i tried the same reports from SSRS web interface i got the following error.

    • An error has occurred during report processing. (rsProcessingAborted)
      • Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
        • System.InvalidCastException: Specified cast is not valid.
          • Specified cast is not valid.

    Any help would be greatly appreciated.

    Thanks,

    Rash

    Tuesday, April 22, 2014 12:06 PM

All replies

  • Seems to be a problem with the data source. Can you check the data source of the report in the Report Mgr (SSRS web interface..)?

    If my response helps you in finding your answer then please click 'Mark as Answer' and 'Vote as Helpful'

    Tuesday, April 22, 2014 12:31 PM
  • Thanks Mamatha, I could find 2 data source

    MSCRM_DataSource and MSCRM_FetchDataSource what should be the proper values, I have configured IFD for the installation

    Tuesday, April 22, 2014 12:45 PM
  • The connection string should be your CRM Org URL and the credentials of the user set.

    Is this a new installation? Have the reports worked previously?


    If my response helps you in finding your answer then please click 'Mark as Answer' and 'Vote as Helpful'

    Tuesday, April 22, 2014 1:50 PM
  • No Its not a new installation, all reports where working fine till yesterday but from today Fetch based reports throws this error

    Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
    • System.InvalidCastException: Specified cast is not valid.
      • Specified cast is not valid.

    Tuesday, April 22, 2014 1:53 PM
  • You should install the SSRS Data Connector for CRM

    Did you make any changes to the system? Is the IFD deployment new?




    Please vote if you find my post helpful - Thanks

    Wednesday, April 23, 2014 1:43 PM