| |
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 -> Cope Selected as Table). Later the information may be pasted in another application (for ex., MS Excel), and create needed report on this data.
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! help@albaspectrum.com
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.
Article Source: http://www.simplysearch4it.com/article/2122.html
| If you wish to add the above article to your website or newsletters then please include the "Article Source: http://www.simplysearch4it.com/article/2122.html" as shown above and make it hyperlinked. |
| Some other articles by Eugene Polyakov | Lotus Domino Implementation and Tuning - Mobile Solutions
Today, the usage of such technologies as e-mailing, WAP, GPRS, calendar, etc. via mobile devices (telephones, PDA) is common. Moreover, the sphere of these technologies extends from using on “entertainment” level to the business level.
...
Lotus Domino - Enterprise e-mail Server
Any success software product developing extends the implementations areas. This is the requisite condition to integrate the software into business, company, etc infrastructure. Practically always such software products have the score which is the ...
Lotus Notes Domino and Web: application development - tips for programmers
Beginning with Domino version R4 it has integration with the Web, and the server itself becomes a HTTP-server. The next releases of Domino Web-server add new functionality (for example servlet managers, supported JVM versions upgrade, ...
Lotus Domino Implementation and Development: Infrastructure - present and future
Domino server is a buffer between the operation system and the application. On the other hand Domino server – consists of the services which support development processing and executing of dynamic, secure applications for Internet, Intranet, ...
Lotus Domino: Application Integration - a programmer view
Alba Spectrum Technologies
USA: 1-866-528-0577, 1-961-5918, Deutschland (0177) 8349 806, Moskau (095) 918 3314, help@albaspectrum.com
There are two approaches for application ...
|
|
| |
|
