Deploying Report to Reporting Server RRS feed

  • Question

  • We are using Dynamics CRM 2011. We have created several reports using BIDS and have deployed them within the CRM system itself. What we were wanting to do was also deply a handful to our reporting server as well. I have not been able to find any information on this and we when tried it we were running into some errors. So before I spent too much time on this I wanted to see if anyone simply knew if this was even possible. Can this be achieved with CRM online?
    Thursday, January 10, 2013 7:53 PM


All replies

  • It won't be possible with CRM online as it uses fetch-based reports only.  

    Jamie Miley
    Check out my about.me profile!
    Linked-In Profile
    Follow Me on Twitter!

    Monday, January 14, 2013 5:46 PM
  • Depending on how you've written the reports, there are a couple of options. If you've written them in SQL it's significantly easier.

    On your SSRS reporting page (http://something/Reports) there's an upload button. Upload your reports to there. Most errors found at this point are to do with the datasource being incorrect (Make sure that: Data Source = YourCRMSQLServer; Initial Catalog = YourCRMDB (in SQL Server); - Make sure the account that runs the report has necessary run permissions etc.

    Then you can use http://something/ReportServer to link people to the report. Is usually found under your organisation name or where you've uploaded the report.

    If you've written them in FetchXML, there's a little bit of work you need to do changing the data-source (Same upload process) - Basically 'Manage' your report under the Reports page, set the DataSource to the correct FetchDataSource (YourOrgansiation/CustomReports/FetchDataSource) and test. You don't want the root data source, you want the ones inside the organisation data source list.

    - Missed the XML bit.

    - Note: This only applies to ON PREM deployments

    Tuesday, January 15, 2013 3:51 PM