Pivot Tables for Excel Reports from Lotus Notes
Microsoft Excel is still a preferred output format for reports from Lotus Notes Applications.
Have you been challenged to create a complex report , which would have data mining features ?
Traditionally using pure Lotus Script alone you will have to run loop after loops to get all the information in the desirable format before dumping into the excel using OLE. Creating Pivot tables programatically can save you a lot of time in coding.
Attached is a simple example.
To produce an equivalent in scripting will involve lot of coding.
Approach
1. Get the data as notes document collection
2. Write the data into excel sheet
3.Provide unique and clear titles for the columns
Things to remember
Lotus Script may not recognize the extented syntax for the OLE object, so every object has to be individually declared and accessed.
Sheet Name shouldnot contain spaces
Sample Code
See the following post in Lotus 4 & 5 forum @ notes.net
http://www-10.lotus.com/ldd/46dom.nsf/0/6d31e42bd43ec002852570c10064def6?OpenDocument