I am using trial CRM online for practice and I need to do SSRS reporting so i need datasource information of the trial version of CRM, can anyone please tell me how to do that...
*This post is locked for comments
I am using trial CRM online for practice and I need to do SSRS reporting so i need datasource information of the trial version of CRM, can anyone please tell me how to do that...
*This post is locked for comments
Hi,
Data source is your URL : https://xxxx.crm.dynamics.com
You can find it in setting-->Customization-->Developer Resource
You can follow below link for creating a SSRS report :
www.codeproject.com/.../Creating-a-SSRS-Report-With-Microsoft-Dynamics-CRM
For data source
Note : You must have VS2013 or above for creating SSRS reports.
If you find it helpful, please mark my answer as verified.
Best Regards,
Shahbaaz
Hello,
For creating SSRS reports for Dynamics 365 (CRM) Online you need to download and install the 'Microsoft Dynamics 365 Report Authoring Extension'
https://www.microsoft.com/en-us/download/details.aspx?id=50375
As your data source you will then be able to select 'Dynamics 365' and enter the URL of your organization as a connection string. Connecting directly to the SQL database is unfortunately not possible online.
Please check out this article on how to get started with building SSRS reports for Dynamics 365 (CRM) Online:
https://community.dynamics.com/nav/b/threadpunter/archive/2017/09/26/ssrs-reports-for-dynamics-365-using-fetchxml
Mohamed Amine Mahmoudi
83
Super User 2025 Season 1
Community Member
52
Victor Onyebuchi
6