About This Code
Brief Description:
Dashboard example v1.2 (realtime Lotus Notes data graphing using RMchart)
Contributor:
F. Kranenburg
Notes Version:
R6.x, R8.x, R5.x, R7.x
Last Modified:
09 Mar 2009
OpenNTF Disclaimer
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.
Code / Description
This application is a sample of how you can create good looking charts from Lotus Notes data without the need of Microsoft Excel.
Because this application directly reads out the values of this database and directly redraws the charts on the form, I think this example is much faster then starting Excel, exporting values, creating a Chart, save it as a graphic to disk and import it in an rich text field within your form.
This version, v1.2, I added the ability to change the look of the charts in real time, and add the data table (as an embedded view). I also added an example of a Pie / Donut chart.
You will need to download RMchart at http://www.rmchart.com/ or http://www.brothersoft.com/rmchart-35638.html 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 their 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.
This appication does not work on the web.
If you have any questions regarding this application, mail me.
Ferry Kranenburg
Usage / Example
Code Attachments
Comments
Posted by Pálmi H Lord on 03/19/2009 03:40:23 PMGreat Job
I have a Install setup for the DLL file so the user can see the Charts - how du you deliver the DLL File ? Great Job
Posted by F. Kranenburg on 03/19/2009 05:11:35 PMinstal dll
We use a loginscript (vb.net) and we use TQCrunas (www.quimeras.com) to install the dll silently to our internal clients. It is also possible to embed the dll into your application and create an installer from within the application.
Posted by F. Kranenburg on 08/06/2009 10:08:05 AMNew project - Realtime Dashboard
http://www.openntf.org/Projects/pmt.nsf/ProjectLookup/Realtime%20Dashboard
It contains the ability to print the charts or even save the charts in a notesdocument (so you could e-mail of archive the report for example).
Posted by Pálmi H Lord on 08/06/2009 02:26:41 PMPrinting
For some reason it only Prints the Pie chart not all of them ? what am i missing ?
Posted by F. Kranenburg on 08/06/2009 02:52:09 PMPreview
Did the other graphs display in the print preview?
The images are saved to the C:\ root and imported in three rich text fields.. If you don't have access there or something, it will go wrong.
Posted by Pálmi H Lord on 08/06/2009 04:25:40 PMPrinting
No just the Pie chart comes up in preview