web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

i want to find out datasource

(0) ShareShare
ReportReport
Posted on by

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 have the same question (0)
  • Suggested answer
    Michel van den Brink Profile Picture
    4,697 on at

    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.

    dyncomm_5F00_mindsunited_5F00_ssrsfetchconnect.png

     

    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 

  • Suggested answer
    Rajkumar Rajaraman Profile Picture
    on at
  • Verified answer
    Shahbaaz Ansari Profile Picture
    6,211 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans