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:
- Integrate with third-party products, which will require installation on your PC ( RMCHART (http://www.brothersoft.com/rmchart-35638.html) is a very good library);
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.
- 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")
- I opened the document with the form above, and I noticed a picture with a "red cross"
- 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