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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Error Connecting to CR...
Microsoft Dynamics CRM (Archived)

Error Connecting to CRM using Report Builder

(0) ShareShare
ReportReport
Posted on by Community Member

Hey guys,

I just found out about SQL Server Report Builder, and this tool looks like a great way to customize the layout of CRM reports without needing to know Visual Studio.

However, while I can open a .rdl file I downloaded from our CRM server, I cannot get the program to connect.

See here:

You can see that the URL is correct...

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    I tried running the program as the same user that the Report Server is running as, that didn't help either.

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Hello,

    If you work and plan to design reports for CRM Online then Report Builder is not an option. Believe me I worked both RB and VS - tools do not have a lot of differences. So your only choice is VS - BIDS (or SQL Server Data Tools how it is called now) + FetchXml Authoring extension installed.

  • Community Member Profile Picture
    Community Member on at

    It's not CRM Online.  It's CRM 2011 on-premise.  We're running SQL Server 2008 R2 Reporting Services.

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Ok. In this case you should use other type of DataSource for your report. You should use SQL Server data source and define connection credentials to your CRM Database.

  • Community Member Profile Picture
    Community Member on at

    So then what do I actually type in the program when it asks for the server? I tried using the IP as well as the hostname and it errors, as you can see in my first post.

  • a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Please provide a screenshot of form where you enter your connection details.

  • Community Member Profile Picture
    Community Member on at

  • a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Hello,

    So enter this information. Do you know Url of your report server (I believe it is not the same as your CRM server)?

  • Community Member Profile Picture
    Community Member on at

    Yes...

    It's the same URL as our CRM server - both CRM server and SQL reporting are running on the same machine... intentionally.

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Ok. Then try to enter url but with Reports or ReportServer on the end (as far as I can see on first screenshot you tried url without it).

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans