PDA

View Full Version : Webform as Chart Source


info22862
05-21-2010, 06:19 AM
Don't hate me, but I'm evaluating WA DWcharts against FushionCharts.

Custom SQL Recordsets
One big deal is that with Web Assist I can't attached a record set as the datasource for the chart. This means I lose out on the ability to easily create complex SQL queries unless I go through that what seems to be a tricky copy and paste and tweeking with the XML editor. Is this really the only way to get a custom record set into WA DC?

Web form input as datasource.
A common and very useful application of charting is to allow visitors to type in data and have you perform some type of calculation and display a graphical analysis. Savings calculators like this are a good example http://www.dinkytown.net/java/RothIRA.html
Ugly formatting but it gets the point across.

These are the main uses of the charting tool for me right now.

FYI - FusionCharts has hands down the most impressive looking charts with 3D, 2D, combined and more. Over 100 styles with animation. You can also attached directly to a record set without any XML manipulation needed. However, the load time for their graphs is painfully slow.

WA has nice clean functionality and the graphs have loaded very fast indeed. However, the extra coding and simplistic limited choices of the graphs concern me a bit. We already own it, but wanted to see if there were a few examples of webform out there we could review.

Thanks!

Jason Byrnes
05-24-2010, 08:56 AM
DWC Will Generate the record set for you.

You can edit the recordset on the data page that is created in the Dynamic web charts directory after the chart is created.


Unfortunately, dynamic web chart does not allow for a form to be used as a data source.

info22862
05-27-2010, 08:03 PM
Thanks Jason.

Thats too bad. Form driven data charts are very popular and extremely useful.
No work-around? Form to DB then to Chart and rollback when done?

Will DC connect to our own custom record sets without having to modify the code after the fact?

Thanks again,

Jerry

Jason Byrnes
05-28-2010, 06:46 AM
Sure you could store the form data into the database to display it in the chart, you just wont be able to use form data directly.


You cannot bind Dynamic Web Charts to a recordset, it will create the recordset for you.

If the recordset that is created is not sufficient, you will need to modify it after the fact.