realtime charts

is it possible to have realtime charts, i know that if it is dynamic it will display from db. however is it possible for the user to have a selection of a form to change the criteria that is displayed in the chart?

many thanks

Yes, you can create a chart from a recordset, and use recordset parameters or DataAssist search to filter that recordset based on a form selection.

can you expand slightly on how i would do this? brief walk through please?

many thanks for your help.

What part do you have difficulty with:

1) Create a form
2) Create a chart based on a recordset
3) Apply DataAssist search to an existing recordset using the form

In the wizard I only see a data source. How do you create a chart from a Dreamweaver recordset.

Choose a data source and the wizard will automatically create the recordset on the data page.

thanks ray, can go through the wizard no probs but how do you use recordset parameters or datassist to bind to the chart to change the data on it?

just not sure how to get pastthat part. know it might seem basic but just getting there step by step.

thanks again

Open up the page in DynamicWebCharts/Data/ where the recordset is and apply the changes to the recordset parameters, or apply the DataAssist Search server behavior on that page.

hi ray,

i appreciate your help, however i am struggling with this.

i am trying to create a page which will have a drop down menu on it with a list of graphs.

so one might be a graph on products sold by user, the other how many clients a user has.

i want to be able to select it from the drop down menu and click an update button and it changes the graph on the page.

can you guide me through this. giving me:

Open up the page in DynamicWebCharts/Data/ where the recordset is and apply the changes to the recordset parameters, or apply the DataAssist Search server behavior on that page.

i just not getting round. remember i bought into webassist as a total newbie to dreamweaver and php etc. so recordsets, session variables etc i am just getting to grips with.

many thanks

It should be possible to do what you describe.

I'd start by getting the lists to work on a page without charts. It will be easier to debug that way.

Once you get a recordset filtered by the submitted list values correctly, then take that logic to your data page and do the same thing to the recordset there.