pcourterelle Posted November 18, 2000 Posted November 18, 2000 I am currently converting a production reporting system to a FMP database which will be accessed via an intranet within the company I work for. 99% of the fields/material are straight forward, entry level stuff. However, it would be of great benefit to be able to present some of the data graphically (ie bar graph showing # units produced over a given time period). There are solutions for FMP , but what about over the web? Any ideas? Thanks in advance pc
Anatoli Posted November 20, 2000 Posted November 20, 2000 If you can create size parameter for picture e.g. <img border="0" height="5" width="[FMP-field: value]" src="blue.gif"> You can produce (I think) simple bar.
dspires Posted November 20, 2000 Posted November 20, 2000 I use a javascript application that generates a bar chart based on the found set from a FMP web query. I can e-mail you the app and CDML that I use, if you like.
Anatoli Posted November 20, 2000 Posted November 20, 2000 quote: Originally posted by dspires: I use a javascript application that generates a bar chart based on the found set from a FMP web query. I can e-mail you the app and CDML that I use, if you like. I am interrested! [email protected] Thank you.
Anatoli Posted November 22, 2000 Posted November 22, 2000 quote: Originally posted by dspires: I use a javascript application that generates a bar chart based on the found set from a FMP web query. I can e-mail you the app and CDML that I use, if you like. Give us the code, please...
dspires Posted November 23, 2000 Posted November 23, 2000 The format file follows, just change the FMP-Field tag and title/label stuff. As far as the javascript application (graph.js) it can be linked to directly using the path in the format file (revised) or it's in my iDisk Public folder (mac 9.0 and better users) plus I copied and renamed the file to "http://homepage.mac.com/dspires/graph.html" so if you view the page source, copy all, paste to your text editor and save as "graph.js" you will be in business. <HTML> <HEAD> <TITLE>Processing Time Graph</TITLE> <SCRIPT LANGUAGE="JavaScript1.2" SRC="http://homepage.mac.com/dspires/graph.js"> </SCRIPT> </HEAD> <Body> <Center><Table BGCOLOR=#FFFFCC> <TR> <TH>Call Board Processing Time:</TH> </TR> <TR> <TD> <SCRIPT LANGUAGE="JavaScript1.2"> var g = new Graph(600,400); g.addRow(0[FMP-record],[FMP-field: GraphElapsed][/FMP-record]); g.scale = 10; g.title = "Processing Time"; g.xLabel = "Calls"; g.yLabel = "Time Min"; g.build(); </SCRIPT> </TD> </TR> </Table> </CENTER> <HR color=black noshade size=5> <P>Displaying records [FMP-rangestart] thru [FMP-rangeend] of [FMP-currentfoundcount] records found. ([FMP-rangesize] records displayed). [FMP-if:issorted.eq.true]<BR> [FMP-CurrentSort] Sorted by field: [FMP-SortFieldItem] [/FMP-CurrentSort] [/FMP-if] </P> </Body> </HTML> [This message has been edited by dspires (edited November 22, 2000).]
dspires Posted December 4, 2000 Posted December 4, 2000 Here is the Netscape Developer area where I found the javascript program above. There are plenty of details provided and some additional capabilities: http://developer.netscape.com/docs/technote/javascript/graph/
flyingmonkey Posted December 11, 2000 Posted December 11, 2000 I am doing a similar thing at my work and I found a third party plugin developer called Waves in Motion that sells a package called 0Azium Charts 2.0. They have a fully functional demo version for download at http://www.wmotion.com. , if I remember right it is roughly $75. It's not free like the javascript solution but it can do any type of chart that excel can make from bar charts to pie chart to gant charts. Since it can do so much it does take a few days to figure it out but it definitely works with the web companion and serves the chart images to the web. [This message has been edited by flyingmonkey (edited December 12, 2000).]
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now