Chart from View in Database

[Anonymous User]

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

[Anonymous User]

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&displa...
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