Lotus Domino: reports and connectors – Crystal Reports, XML, ODBC/JDBC, OLE
Written by Eugene Polyakov
Lotus Notes Domino is very efficient in electronic document workflow automation. Unfortunately the electronic document workflow can not replace paper documents completely. For example some documents should be sent to your suppliers or customer in ....
Lotus Domino: reports and connectors – Crystal Reports, XML, ODBC/JDBC, OLE
by: Eugene Polyakov
Lotus Notes Domino is very efficient in electronic document workflow automation. Unfortunately the electronic document workflow can not replace paper documents completely. For example some documents should be sent to your suppliers or customer in paper form. Lotus Notes (as a client) has built-in tools for printing documents, views and folders. But inbuilt Lotus Notes mechanisms providing such services as printing on the paper Domino database contents can not solve all reports generation objectives.
Regular printing mechanisms of Lotus Notes client allow the following:
Print one or several documents from Domino database vis Lotus form. A developer can create the form in Domino, which will be used for the printing. In simple cases the printing will be correct. If the form is complex (for ex. It has many design elements, such as inbuilt views, sections, etc.), then the problems may begin to show up (wrong indents, fonts, text imposition, etc.);
Print data from view, folder in table format. So in this case developer is very limited in report’ s design;
In Domino R6 two more mechanisms were added some-how connected with printing:
automatic preparation for contact information from a document printing (function Contact print). In other words –information printing from document in envelope label form;
copying of selected in view/folder documents into clipboard (menu Edit -
Thus, as we can see, regular Lotus Notes mechanists cannot solve all tasks in reports creation. For instance, using such the mechanisms it is not possible to create histograms, based on Domino data.
In order to create full-featured reports in Notes/Domino it is necessary to deploy integration technologies. Following technologies could be used:
Creation in Notes/Domino functionality which loads data into external applications in the required formats. In this case developer is limited only by integration mechanisms which are supported by Notes/Domino (for ex. XML, ODBC/JDBC, OLE, etc);
External application way, pulling data from Notes/Domino. For example, it may be Crystal Reports;
OLE. OLE allows reliable connection to Lotus client and data extraction and even processing. Author is familiar with two successful projects in this field, realized by IBM business partners. Both use OLE technology, which works seamlessly at the Notes client side (not on Domino server).
The summary of this article is – Complex reporting of the Notes/Domino databases is possible, but usually we see the common needs to go beyond standard built-in printing mechanism, inbuilt in Lotus Notes client.
Good luck in your system setting up and contact us for any help in USA: 1-866-528-0577, Germany: (0177) 8349 806!
About The Author
Eugene Polyakov is a technical writer in Ronix Systems ( http://www.ronix-systems.com ) the European branch of Alba Spectrum Technologies ( http://www.albaspectrum.com ), IBM and Microsoft Business Solutions Partner, serving clients in Chicago, Miami, New York, Los Angeles, San Francisco, Denver, Phoenix, Houston, Atlanta, Germany, UK, Australia, South Africa, Brazil, Moscow.
(NC)-As the first smog alert warnings of the season approach, Canadians are being urged to use ethanol-blended fuel to alleviate the urban smog problems plaguing many parts of the country. Many regions such Vancouver, Calgary, Montreal and most pa....
Read more
Low Speed impacts are those that take pace at speeds under 10 MPH. There’s often little (if any) visible Property Damage done to the rear of ones motor vehicle. However, those who are struck (especially in the rear) often have injuries, especially....
Read more
Remember back when selling online was a new experience? Dealers tried everything to sell their vehicles online. Today’s market has expanded to include several hot online marketplaces but there is the largest online marketplace, Ebay. Ebay has e....
Read more
Remember back when selling online was a new experience? Dealers tried everything to sell their vehicles online. Today’s market has expanded to include several hot online marketplaces. The largest online marketplace is Ebay. Ebay has evolved in....
Read more
What does BPU™ stand for? (BPU™ is a trademark of SupraStore.com)Basic Performance Upgrades. These modifications are: A full length three inch down-pipe (with or with-out high flow cats), 3” (75mm) or bigger cat-back exhaust system, raised boost....
Read more
