Create chart from query

All replies

• 

  

  1

  Sign in to vote

  Use SQL Server Reporting Services. There are some cool charts available OOB in SSRS and they are flexible enough to represent your information, drill down and many more features.

  ---

  Ayaz Ahmad CRM Architect | http://ayazahmad.wordpress.com

  • Proposed as answer by Ayaz.AhmadModerator Wednesday, August 10, 2011 1:39 AM

  Wednesday, August 3, 2011 12:07 AM

  Moderator
• 

  

  1

  Sign in to vote

  Using SSRS to create the report which is you want, then enbed it in the dashboard.

  ---

  daemon lin

  • Marked as answer by KatRiketa Tuesday, August 16, 2011 3:47 PM

  Wednesday, August 3, 2011 6:02 AM
• 

  

  0

  Sign in to vote

  I found a Solution which enables to embed a SSRS report in a Dashboard. That way I can put a chart made of custom query on the dashboard. It looks like the green doughnut chart on the top left.

  http://blogs.msdn.com/cfs-filesystemfile.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-00-55-55-metablogapi/6443.clip_5F00_image002_5F00_59A660EF.jpg

   

  Is there a way my chart, which is made of custom query from multiple entities, to be like the ones on the right side of the dashboard?

  
  

  Wednesday, August 3, 2011 5:05 PM
• 

  

  1

  Sign in to vote

  Hi Mite,

            You can use "Visualizations" for your requirement. However, only OOB CRM Charts and few of the ASP.Net chart controls can be utilized. 

  Here is the sdk article on Creating Visualisation. 

  http://msdn.microsoft.com/en-us/library/gg334267.aspx

  ---

  Vikranth http://howto-mscrm.blogspot.com "Please Mark it as answer if it helps in resolving your query"

  • Proposed as answer by Vikranth Pandiri Wednesday, August 3, 2011 8:29 PM

  Wednesday, August 3, 2011 7:11 PM
• 

  

  0

  Sign in to vote

  Thanks for the suggestion. How can I do a drill down on a report made in SSRS? When I try to embed it through the solution it just displays the graph as a report.

   

  Wednesday, August 3, 2011 9:17 PM