Hi,
I developed a SSRS report in Bids 2010, joining two datasets, one was built on SQL Server database with T-SQL statement, another was built on Microsoft Dynamics CRM Fetch with fetchXml. The report ran well in Bids. However, I want to
deploy it to a report server (SQL Server 2008 R2 or SQL Server 2012). I get all kinds of errors. The major errors said it does not support CRM Fetch. What I have to install in report server in order to run the report in Report Manager?
Error 1: An attempt has been made to use a data extension 'MSCRMFETCH' that is either not registered for this report server or is not supported in this edition of Reporting Services (rsDataExtensionNotFound).
Error 2: Cannot create a connection to data source 'XXXXXX'. (rsErrorOpeningConnection)