About This Code
Brief Description:
Dashboard example (realtime data into graphs using RMchart)
Contributor:
F. Kranenburg
Notes Version:
R6.x, R8.x, R7.x
Last Modified:
12 Jan 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
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
** update 1.1 - added the rewritten fastview function from Ulrich Krause (Thanks!)
Usage / Example
Code Attachments
Comments
Posted by Ulrich Krause on 12/29/2008 07:06:13 AMModified var_FastViewLookup
http://www.eknori.de/2008-12-29/get-view-column-sums-with-lotusscript/
Posted by F. Kranenburg on 01/12/2009 10:18:51 AMmodified database
I updated the database with the rewritten function from Ulrich Krause.
Posted by Yan Mingyang on 02/07/2009 12:19:23 AMvery good
Thanks for you share
Posted by fatih duranoğlu on 03/07/2009 03:23:53 PMPlease Help me
How Can I Design My Dashboard Like Yours. I need to manual about your sample because i cant run your sample completely.I installed rmchart software after I opened your sample everythings ok but i added new entry to sample database it's not show on bar chart.
Posted by F. Kranenburg on 03/08/2009 06:01:34 AMa bug
Dear fatih duranolu, you are right, that is a sloppy bug. I will change it as soon as possible.
For now can should change the code in the ' postrecalc' section of the ' frm_Dashboard' form.
The variable 'cols' contains an array of column numbers that it should read the values from.
Change the variable 'cols' to this and it will work as it should:
Dim cols (11) As Integer
cols(0) = 1
cols(1) = 2
cols(2) = 3
cols(3) = 4
cols(4) = 5
cols(5) = 6
cols(6) = 7
cols(7) = 8
cols(8) = 9
cols(9) = 10
cols(10) = 11
cols(11) = 12
I will try to extend this example so you can change graphs and charts at runtime and choose your own colors or whatever.
Posted by F. Kranenburg on 03/08/2009 08:23:32 AMnew version v1.2 here
http://www.openntf.org/Projects/codebin/codebin.nsf/CodeByDate/10D94F4166FE05668625757300492E9A?OpenDocument