November 18, 200025 yr 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
November 20, 200025 yr 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.
November 20, 200025 yr 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.
November 20, 200025 yr 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.
November 22, 200025 yr 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...
November 23, 200025 yr 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).]
December 4, 200025 yr 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/
December 11, 200025 yr 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).]
Create an account or sign in to comment