How to create a piechart from a database

Question

User-1222178136 posted

I have a database in would like to make a piechart form it,the database has a column for the different blood groups e.g (A-,A+,O,B-,B+) and all these appear several times.I would like to know the sql server query that can count and return how many times each blood group appears in the blood group column.After that i would like to know how i can represent the results on a pie chart? thanks!

Answer 1

User1711366110 posted

.I would like to know the sql server query that can count and return how many times each blood group appears in the blood group column.After that i would like to know how i can represent the results on a pie chart?

   As per this case, I suggest to refer the following tutorials which explains that how to add a pie chart with sqlserver data through report builder in step by step process :
1. https://msdn.microsoft.com/en-us/library/dd255283.aspx

2. http://www.databasejournal.com/features/mssql/creating-chart-reports-in-ssrs-sql-server-2008-r2.html

Further any queries , kindly convey to us.

Answer 2

User177399542 posted

Hi karcks 

You can use following techniques to generate pie charts from database:

1) Using inbuilt chart control in asp .net visual studio:

http://www.aspsnippets.com/Articles/Create-ASPNet-Chart-Control-from-Database-using-C-and-VBNet-Example.aspx

2) Using Ajax control toolkit Pie chart extender: 

http://www.aspsnippets.com/Articles/ASPNet-AJAX-Pie-Chart-Control-Populate-from-Database-example.aspx

3) Using third party chart compnents. Here is an example of google pie chart:

http://dotnetawesome.com/Google/Chart