All of the program code and information presented in the OpenNTF.org Code Bin are provided "as-is", and should be used at your own risk. OpenNTF.org make no express or implied warranty about anything in the Code Bin, and OpenNTF.org will not be responsible or liable for any damage caused by the use or misuse of anything from this site. OpenNTF.org makes no guarantees about anything. Please thoroughly test all of the knowledge and code you find here before you attempt to use them in your production environment.

In this sample application I show you how you can use RMcharts in an Lotus Notes Dashboard application.

You need to download RMchart at http://www.rmchart.com/ and install it on your PC (a restart is required).
Make sure the files RMchart.ocx and RMchart.dll are installed in your windows\system32 directory.
RMchart is completely freeware. Go to the website for more information.

I created this application because I could not find any free product to create realtime graphs from (view) data within Lotus Notes. Finally I found this software and this made my work a lot easier. No more excel and no more exports needed.
This is a completly free solution and I think it works great. If you would like to use RMcharts in a real application make sure your users have the RMcharts installed. You could copy above files manualy or automatic via an script to windows\system32\ directory and use 'regsvr32' command line program to register the .ocx file in Windows.

This database contains a view for the sales sample data and a lookup view I use to quickly & dynamic get the values to display in the charts.
The dashboard form contains the embedded activex elements and all the code I used to get the data and display the data in the embedded activex elements. It makes use of a script library for the needed constants.

TIP: You can build your own charts with RMCdesigner, also available at www.rmchart.com.
Use the program to generate source code for VB6 / ActiveX and paste it in an Lotus Notes button in a form.
With very limited changes you can use that generated code in your application.

If you have any questions regarding this application, mail me.

Ferry Kranenburg