Chart from View in Database

Anonymous User — Tue, 08 Jun 2010 18:41:24 GMT

Original User: ereed

Is it possible in the sample viewer to create a chart based on a view in SQL Server rather than from a layer in a map service?

Thanks,

Ed

Re: Chart from View in Database

Anonymous User — Wed, 09 Jun 2010 01:59:55 GMT

Original User: cgishack

In order to get the data from a SQL Server DB you have a few options...

If the relationship is a 1 : 1 ratio you can join the data to a related layer then use the map service & flex to build the chart on the client side.

Another option is to build a custom web service (ie .NET web service) and return the values to build the chart on the flex side.

Finally another option is to use a .NET web service and MS Charts and return a static image (i.e jpg) from the service
MS Charts:
http://www.microsoft.com/downloads/details.aspx?FamilyID=130f7986-bf49-4fe5-9ca8-910ae6ea442c&displaylang=en
MS Charts Samples:
http://code.msdn.microsoft.com/mschart

Personally I would create a custom .NET web service, then return the results to Flex and use its charting capabilities.

Drew

topic Chart from View in Database in ArcGIS API for Flex Questions

Chart from View in Database

Re: Chart from View in Database