Management asked for views that could not be built because the documents needed to be categorized on Field two when Field one was the key. To solve this dilemma we built a reporting database, and created report documents there.
An agent, written in LotusScript, builds a collection of documents, finds the corresponding documents according to a key and creates a new "report" document combining selected fields from both. This new report document is now used in the report views, and categorized views can be written against any field in the report document.
Do you have comments on this tip? Let us know.
This tip was submitted to the SearchDomino.com tip library by member Pat Cote. Please let others know how useful it is via the rating scale at the end of the tip. Do you have a useful Lotus Notes, Domino, Workplace or WebSphere tip or code snippet to share? Submit it to our monthly tip contest and you could win a prize.