Russell, last year I created some custom scorecard type graphs using SVG (scalable vector graphics - a W3C recommendation). I wrote some custom classes in VFP and rendered the content in a web browser using an SVG Viewer (download the free Adobe SVG Viewer here:
For more info, check out Lauren Clarke's excellent paper on VFP and SVG at the following url:
thru and including and save it in a file with an extension of .SVG. Open the file in a web browser and see if this is what you are after.<?xml version="1.0"?>
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.0//EN" "http://www.w3.org/TR/2001/REC-SVG-20010904/DTD/svg10.dtd">
<svg width="285" height="135">
<defs>
<linearGradient id="redtowhite" x1="100%" y1="100%" x2="0%" y2="0%">
<stop offset="0%" style="stop-color:red;stop-opacity:1"/>
<stop offset="75%" style="stop-color:#FFB6C1;stop-opacity:1"/>
<stop offset="100%" style="stop-color:#FFB6C1;stop-opacity:1"/>
</linearGradient>
<linearGradient id="yellowtowhite" x1="100%" y1="100%" x2="0%" y2="0%">
<stop offset="0%" style="stop-color:yellow;stop-opacity:1"/>
<stop offset="75%" style="stop-color:#FFFACD;stop-opacity:1"/>
<stop offset="100%" style="stop-color:#FFFACD;stop-opacity:1"/>
</linearGradient>
<linearGradient id="greentowhite" x1="100%" y1="100%" x2="0%" y2="0%">
<stop offset="0%" style="stop-color:green;stop-opacity:1"/>
<stop offset="75%" style="stop-color:#9AFF9A;stop-opacity:1"/>
<stop offset="100%" style="stop-color:#9AFF9A;stop-opacity:1"/>
</linearGradient>
<marker id="myMarker" viewBox="0 0 10 10" refX="1" refY="5" markerUnits="strokeWidth"
orient="auto" markerWidth="4" markerHeight="3">
<polyline points="0,0 10,5 0,10 1,5" fill="#00f" />
</marker>
<text id='t01'>85.72</text>
<text id='t02'>86.02</text>
<text id='t03'>86.32</text>
<text id='t04'>86.62</text>
<text id='t05'>86.91</text>
<text id='t06'>87.21</text>
<text id='t07'>87.51</text>
<text id='t08'>87.81</text>
<text id='t09'>88.10</text>
<text id='t10'>88.40</text>
<text id='t11'>88.70</text>
<text id='t12'>89.00</text>
<text id='t13'>89.29</text>
<text id='t14'>89.59</text>
<text id='t15'>89.89</text>
<text id='t16'>90.19</text>
<text id='t17'>90.48</text>
<text id='t18'>90.78</text>
<text id='t19'>91.08</text>
<text id='t20'>91.38</text>
<text id='t21'>91.67</text>
<text id='t22'>91.97</text>
<text id='t23'>92.27</text>
<text id='t24'>92.57</text>
<text id='t25'>92.86</text>
<text id='t26'>93.16</text>
<text id='t27'>93.46</text>
<text id='t28'>93.76</text>
<text id='t29'>94.05</text>
<text id='t30'>94.35</text>
<text id='t31'>94.65</text>
<text id='t32'>94.95</text>
<text id='t33'>95.24</text>
<text id='t34'>95.54</text>
<text id='t35'>95.84</text>
<text id='t36'>96.14</text>
<text id='t37'>96.43</text>
<text id='t38'>96.73</text>
<text id='t39'>97.03</text>
<text id='t40'>97.33</text>
<text id='t41'>97.62</text>
<text id='t42'>97.92</text>
<text id='t43'>98.22</text>
<text id='t44'>98.52</text>
<text id='t45'>98.81</text>
<text id='t46'>99.11</text>
<text id='t47'>99.41</text>
<text id='t48'>99.71</text>
<text id='t49'>100.0</text>
</defs>
<g transform="translate(10,-10) scale(0.5)">
<path d="M250,250 L450,250 A200,200 0 0 0 350,76.795 Z" style="fill:url(#greentowhite);stroke:black;stroke-width:1"/>
<text x="350" y="76.795" font-size="22" text-anchor="start">95.24
<tspan font-size="18" fill="blue">(Budget Target)</tspan>
</text>
<path d="M250,250 L350,76.795 A200,200 0 0 0 150,76.795 Z" style="fill:url(#yellowtowhite);stroke:black;stroke-width:1"/>
<text x="150" y="76.795" font-size="22" text-anchor="end">90.48</text>
<path d="M250,250 L150,76.795 A200,200 0 0 0 50,250 Z" style="fill:url(#redtowhite);stroke:black;stroke-width:1"/>
<g transform="translate(250 250)">
<line x1="0" y1="0" x2="0" y2="-184" style="stroke-width:6;stroke:#00f;marker-end:url(#myMarker)">
<animateTransform attributeName="transform" type="rotate" dur="10s" values="-90;90" repeatCount="indefinite"/>
</line>
</g>
<path d="M250,250 L300,250 A40,40 0 0 0 200,250 Z" style="fill:gray;stroke:black;stroke-width:1" />
<text style="fill:black;font-size:22;text-anchor:middle;">
<tspan x="50" y="250" text-anchor="end">85.72</tspan>
<tspan x="452" y="250" text-anchor="start">100.0</tspan>
</text>
<text x="250" y="243" style="fill:white;font-size:30;text-anchor:middle;">
<tref>
<animate attributeName="xlink:href" dur="10s"
values="#t01;#t02;#t03;#t04;#t05;#t06;#t07;#t08;#t09;#t10;
#t11;#t12;#t13;#t14;#t15;#t16;#t17;#t18;#t19;#t20;
#t21;#t22;#t23;#t24;#t25;#t26;#t27;#t28;#t29;#t30;
#t31;#t32;#t33;#t34;#t35;#t36;#t37;#t38;#t39;#t40;
#t41;#t42;#t43;#t44;#t45;#t46;#t47;#t48;#t49"
repeatCount="indefinite"/>
</tref>
</text>
<rect x="50" y="250" width="400" height="30" style="fill:black;stroke:black;"/>
<text x="250" y="274" style="fill:white;font-size:34;text-anchor:middle;">Description goes here</text>
<text x="250" y="150"
style="fill:black;font-family:Comic Sans MS;font-size:26;font-style:italic;text-anchor:middle;">
Company Name
</text>
<polygon transform="translate(170,105) scale(1.5)" style="stroke:black; fill:#00EE00;"
points = "55,35 45,50 50,50 50,60 60,60 60,50 65,50" />
</g>
</svg>>Does anyone of know of a "dashboard" product for business intelligence reporting that can work with VFP tables. It would seem that most any such product could work with VFP tables if it accesses the tables via VFP, however some products are - suprisingly - abandoning ODBC. For instance, Crystal's Excelsius (sp?) product now only supports XML and web services. Has anyone used a good dashboard product with VFP tables?
>
>Thanks,
>
>Russell Campbell
