CODEWITHSUNDEEP
sql-serverdynamics-crm-2011dynamics-crm
Cory Dee
Cory Dee

Reputation: 2891

Add SQL Results To A Dynamics CRM Report

I have some SQL that I've written that I ultimately want the results to appear on a Dashbord. I've saved it as a View in SQL Server, but have no idea where to begin to make Dynamics aware of that View, and accessing the data in a way that I can add it to a dashboard.

I've looked high and low, and haven't found any answers. Most are people saying that they are doing this sort of thing, and are having SQL logic issues.

Thanks in advance for the help.

Upvotes: 0

Views: 512

Answers (2)

nixjojo
nixjojo

Reputation: 617

You can create a SSRS report and put it onto the form:

http://mscrmshop.blogspot.sg/2012/02/step-by-step-tutorial-to-add-crm-report.html

Upvotes: 0

Jason Lattimer
Jason Lattimer

Reputation: 2848

One option would be to convert your view to a SSRS report which is stored in CRM (Workplace -> Reports).

Create Reports for Microsoft Dynamics CRM Using SQL Server Reporting Services

Once there, you can add the report to a dashboard.

How to Display a Report in a Dashboard in Dynamics CRM 2011?

Upvotes: 1

Related Questions