close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

generate amount due pie chart

Thread began 3/24/2010 7:35 pm by mr hankey | Last modified 3/30/2010 3:25 pm by Ray Borduin | 2285 views | 20 replies |

mr hankey

generate amount due pie chart

hi,

i want to create a pie chart that shows the amount due from each table in my database.

basically i have 6 tables which are product tables, each have an amount column in them and a a datepaid column.

i need to show a graph which add up all the amounts in table 1 and gives a value and same for table 2 etc and displays it in a pie chart. it also needs to check that the date paid column is null as this needs to show before it is paid.

i need to of these graphs, one unique to the userid who has logged in and only shows his clients amount due and another that shows all the users in the databases totals for their clients.

can someone help me configure this please, if need be a support ticket to work on and complete this project as i am desperate to get this done.

thanks again for your support

Sign in to reply to this post

Ray BorduinWebAssist

Well... I wouldn't start with the chart.

Start by just creating a recordset that returns the correct data. It will be a matter of writing the correct SQL statements to get the data that you want.

Unfortunately it will be difficult for anyone to help you without knowing exactly what your database structure is and what data you are trying to get precisely from what columns.

You will probably have to give it some sort of try first, then post the SQL statement you are using and what does and doesn't work with it and somebody can probably help from there. There really isn't enough specific information about your database to give you the specific information you are looking for about how to get the information out of your database.

Sign in to reply to this post

mr hankey

hi ray,

my post with the query to get amount due on datassist forum/search all clients is the recordset i would be using to generate the graph.

could you help?

thanks again ray.

Sign in to reply to this post

Ray BorduinWebAssist

I see... perhaps a UNION JOIN was correct then ;) hard to give good advice out of context I guess.

Sign in to reply to this post

mr hankey

haha thanks ray, so when generating my graph can i add this custom query in somewhere to generate?

thanks again

Sign in to reply to this post

Ray BorduinWebAssist

Yeah, you would be able to edit the recordset on the data page that is used to generate the chart.

The hard part is getting the correct query, from there using it to chart should be pretty easy.

Sign in to reply to this post

mr hankey

thanks ray so can you create the chart from a recordset? is this through the wizard or does it need to be edited in the files generate by dynamic web charts?

so do you think i should change the query you gave me to union now?

thanks again

Sign in to reply to this post

Ray BorduinWebAssist

Yeah, if you are doing a pie chart you will want to use a UNION.

Instead of joining in the user data, I'd probably pass in the userid through a url parameter and create a separate recordset for the user information.

Then add where clauses to each of your union select statements to filter those results by user as well.

Sign in to reply to this post

mr hankey

thanks ray, so if i was not using a pie chart just use JOIN?

also where do i add it to generate the graph? is it in the files generate and add in manually?

thanks again ray

Sign in to reply to this post

Ray BorduinWebAssist

Yeah, just use the joins to get data if you aren't charting it. UNION SELECTS would be needed to get the separate rows for each data set that charting would require.

You could just create a static graph or a basic recordset driven graph using the wizard, then you would open the data file to add your recordsets and minipulate the xml from there.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...