Personal tools

Nov 03, 2010

Lotus Notes and chart in client: great stuff!!

A way to render charts in Lotus Notes Client through Google Charts

Working with the Lotus Notes Client I came across the necessity of working with graphs.
The opportunities were:


  • Using Microsoft Excel, if it is installed on your PC, creating a template that is then filled with data and processes them in a chart


Then I thought, why not use Google Charts?

So I did a test, that list step by step.

  1. In the form that contains my data to process I created a pass-thru <computedvalue> containing the URL of Google (ie "http://chart.apis.google.com/chart?cht=p3&chd=s:Uf9a&chs=250x100&chl=January|February|March|April")
  2. I opened the document with the form above, and I noticed a picture with a "red cross"
  3. Right click on the picture I noticed the option "Show images", selecting the image appears correctly


Everything ok, but how to avoid each time you select "Show images"?

If you go on the properties of the document you will notice that there is a field "$DelayedImages" to 1, when the red cross is shown on the image
However if you have selected the option "Show Images" has a field 
"$DelayedImagesOK" set to "ok".
So, in document form, i've created a computed field "$DelayedImagesOK" with value" ok "and you're done!

This is the result

chart

Filed under: ,
comments powered by Disqus