Skip to main content

Notifications

Announcements

No record found.

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

  • Verified answer
    Shahbaaz Ansari Profile Picture
    6,211 on at
    RE: i want to find out datasource

    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

  • Suggested answer
    Rajkumar Rajaraman Profile Picture
    on at
  • Suggested answer
    Michel van den Brink Profile Picture
    4,697 on at
    RE: i want to find out datasource

    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 

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics CRM (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 52

#3
Victor Onyebuchi Profile Picture

Victor Onyebuchi 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans