JD Edwards–graphs on forms–easy!

[with respect] JD Edwards forms are traditionally boring…  But you can easily add some sizzle to your forms with graphs!

It’s very easy to add a graph control to a form and then feed it with dynamic data.  Sure – it’s no OVR (One View Reporting), but it’s pretty snazzy and easy to show simple dashboard information graphically.

Note that you can use our demo server for this, but you’ll need to register for a username and password first. http://e91demo1.myriad-it.com/jde/E1Menu.maf

Then use the following to see sample graphs and XML.

http://e91demo1.myriad-it.com/jde/GraphPrototype.maf

I believe that you can use the following to see how simple it is to create. 

So this form is really handy for you to being your graphing work.  This should you sample XML and sample graphs for the XML (or graphs and their XML, depending on how your brain works).  So – what do you need to do?  Quite simply put a graph control on your form and feed it the XML.

You can easily write a BSFN or a NER that will generate the XML for your graph and put it on the form. – The XML is easy to read – as seen below

<?xml version="1.0" encoding="utf-8"?>
<!-- This text is only visible when the system is on an incorrect Tools release. -->
<!-- Please contact your system administrator to upgrade to the most recent XYZ service pack. -->
<Graph graphName="bar_basic">
<O1Title text="Week Ending" visible="true"/>
<Y1Title text="Cost Variance (USD)" visible="true"/>
  <LocalRelationalData>
    <Row columnKey="9/1/05" rowKey="Actual Variance" dataValue="1504" />
    <Row columnKey="9/8/05" rowKey="Actual Variance" dataValue="980" />
    <Row columnKey="9/15/05" rowKey="Actual Variance" dataValue="-675" />
    <Row columnKey="9/22/05" rowKey="Actual Variance" dataValue="784" />
    <Row columnKey="9/29/05" rowKey="Actual Variance" dataValue="0" />

    <Row columnKey="9/1/06" rowKey="Actual Variance" dataValue="1504" />
    <Row columnKey="9/8/06" rowKey="Actual Variance" dataValue="980" />
    <Row columnKey="9/15/06" rowKey="Actual Variance" dataValue="-675" />
    <Row columnKey="9/22/06" rowKey="Actual Variance" dataValue="784" />
    <Row columnKey="9/29/06" rowKey="Actual Variance" dataValue="0" />
   
  </LocalRelationalData>
</Graph>

And another with some colour

<?xml version="1.0" encoding="utf-8"?>
<!-- This text is only visible when the system is on an incorrect Tools release. -->
<!-- Please contact your system administrator to upgrade to the most recent XYZ service pack. -->
<Graph graphName="pie_basic">
  <LocalRelationalData>
    <Row columnKey="January 2005" rowKey="On Time" dataValue=".11" />
    <Row columnKey="January 2005" rowKey="Early" dataValue=".21" />
    <Row columnKey="January 2005" rowKey="Late" dataValue=".05" />
    <Row columnKey="January 2005" rowKey="Past" dataValue=".12"  />
    <Row columnKey="January 2005" rowKey="History" dataValue=".25" />
    <Row columnKey="January 2005" rowKey="Now" dataValue=".03" />
    <Row columnKey="January 2005" rowKey="Then" dataValue=".14" />
    <Row columnKey="January 2005" rowKey="When" dataValue=".09" />
  </LocalRelationalData>
</Graph>

So – sure it’s a little basic, but add some colour to your users lives!  this is a NO charge piece of functionality that is yours. 

Remember that with the power of RIA, you could do some awesome things with 3rd party dashboard providers.  So you could form your data and just post to to a provider that would host your dashboard, then things could start to get super funky!

I’ll post my sample graphs that I’m using in my performance dashboard project shortly.