Flex Builder 3
MS SQL Server
I would like to create a pie chart from the data stored on a MS SQL database. The data was generated from an online survey where users rated elements of an event with either "Excellent," "Good," Not So Good," and "Poor." I connected to the database using the "Create Application from Database" wizard, but I am having difficulty binding the data to a pie chart. I would like to take the responses from one column in the database and chart the users responses. I don't know where to begin. Is there a tutorial out there that would walk me through the process of connecting to a SQL database then binding the data from one column to a chart? I assumed that if I connected to the database, it should be simple to reference specific data within it. Any help would be very much appreciated.
Try this video. It covers all the basics and I was able to get a chart pulling data relativley quickly (though I had to format my data on the client to get it into the array collection).