Lotus Domino: Reports and Connectors – Crystal Reports, XML, ODBC/JDBC, OLE
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
P.Gottmann 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.
Related Articles:
Microsoft CRM Integration with Lotus Notes Domino: Messaging Connector – Future Directions
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management) from now on can work in tandem. Microsoft CRM Lotus Notes Domino connector from Alba Spectrum Technologies provides seamless messaging in MS CRM through Domino.
Bangkok's Novotel Lotus Hotel Saves $1.6 Million (THB) in Annual Fuel Costs, Cuts Emissions, Using Leading Fuel Saving Technology
The Novotel Lotus Hotel expects to save more than $1.6 million (THB) each year in fuel costs and substantially reduce the amount of greenhouse gases (GHG's) it releases into the environment as the first off-grid city center corporate hotel in Asia to deploy the Etorus FE, a leading fuel saving technology.
Fleur De Lotus: Purity in a Sullied World
Rising from a muddy pond, a lotus flower blossoms. Such epitome of purity in a turbid environment has sparked off much inspiration in ancient oriental literature and Buddhist teachings, shaping a repertoire of odes to the graceful demeanour and refreshing fragrance of the lotus.
Indy Comic Book Gets Unplugged with Platinum
Co-creators Dennis Budd and Joe Caramagna are pleased to announce that they have entered a licensing agreement with Platinum Studios to produce and distribute wallpapers, ring tones, and a mobile comic for wireless devices, PDAs and Smartphones based on their 2006 comic book Model Operandi?. The platinumstudiosmobile.com site launched this week(now called PT78, the chemical symbol for platinum) with Model Operandi as its featured product.
Microsoft CRM Lotus Notes Domino Connector FAQ
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being two groupware products from competing software development leaders, however could coexist within one organization computer network and even work together in collaboration. There maybe multiple reason why corporation would use both products: licensing, commitment to IBM Lotus Notes as legacy product, risk balancing – staking on both Microsoft and Java/EJB/J2EE platforms, deploying Lotus advanced workflow to automate document management, etc.
This March, Refresh and Renew at the Renaissance Orlando Resort's Nèu Lotus Spa
The Renaissance Orlando Resort's brand new nèu lotus spa, slated to open March 1, 2008, promises to be a journey of restorative discovery and features a full menu of signature nail services as well as customized, results-oriented facial, massage and body services, perfect to warm the chill from many cold winter months.
Friends of World Heritage Teams Up with Indiana Jones? to Offer Travelers the Chance to Follow in Indy's Footsteps
In coordination with the release of Indiana Jones and the Kingdom of the Crystal Skull?, Friends of World Heritage--a grassroots initiative dedicated to raising awareness and funds for the protection of UNESCO World Heritage sites--is calling on individuals to test their World Heritage and Indiana Jones knowledge through its interactive and educational Adventure Quiz.
SWING Integrator 5 Provides Better Ties between Lotus Notes and OpenOffice
The new release adds OpenOffice integration with IBM Lotus Notes applications.
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, or Extranet.
Car Brief: 2006 Lotus Exige
The Lotus Elise has put this British manufacturer of pure sports cars back on the map in the United States, racking up thousands of sales thanks to an irresistible bang-for-the-buck quotient combined with guaranteed exclusivity.
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, etc).
Lotus Professional Services Opens in Scottsdale, AZ
Lotus Professional Services, an insurance and investment consulting service, has recently opened its doors in Scottsdale, AZ. Lotus provides quality planning, consultation, seminars and information on life insurance, annuities and health insurance to the marketplace, without the bias of a commission or captive product.
New Fresh Squeezed Lemon Paraffin from Therabath®PRO® Features Lotus Touch® Lemon Essential Oil
Therabath® Paraffin Products, a division of WR Medical Electronics Co., has introduced a fresh, new Lemon scented refill paraffin infused with Lotus Touch® therapeutic grade Lemon Essential Oil.
Migrate Lotus Notes Emails to Outlook
Lotus Notes is the most popular client-server, collaborative application developed and sold by IBM Software Group. IBM defines the software as an integrated desktop client option for accessing business emails, calendars, to-do lists, business contacts.
Sporting Woman Magazine and Indianapolis Host Ultimate Indy Getaway Contest
Indianapolis and Sporting Woman magazine will be offering one of their lucky national readers (and guest) the chance to experience Indianapolis and the largest single-day sporting event in the world, Indy 500, up-close and personal Memorial Day weekend. Via a police escort, the winner will zoom into the famous Indianapolis Motor Speedway in a custom Indy racecar with two tickets to the Indy 500 and a private tour of the pits and garage area. In 50 words or less, contestants must tell why they would like to head to the "Racing Capital of the World" to see Sarah Fisher and Danica Patrick compete. Entry form online at www.sportingwoman.com.