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.
IntroductionSurprised, by the title? well, this is a tour of... Read More
The purpose of one of our projects was MS Exchange... Read More
Microsoft Business Solutions Great Plains has substantial market share among... Read More
Best Software Act! is very popular CRM for small and... Read More
Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More
Let's first look at your ERP system selection (without Retail... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
If you have Microsoft Great Plains and support it for... Read More
As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More
Today's business world is fast-paced. No matter what it is... Read More
Manufacturing in the USA is far away down from mid... Read More
Internet worms. Is your PC infected?If your computer has become... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
It is possible that if one avoided all sources of... Read More
Microsoft Retail Management System serves retail single store as well... Read More
Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More
Now that spyware is the single most dangerous threat to... Read More
Bar charts, bar graphs, and any other chart or graph... Read More
Domino server is a buffer between the operation system and... Read More
In the previous ISDN article, we looked at how and... Read More
Since technology changes so quickly, it is hard to begin... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
We don't think about mainframe software pricing anymore, we just... Read More
When Great Plains Software was designing and developing Great Plains... Read More
If you have been running Windows XP for a couple... Read More
Several years ago Microsoft purchased Great Plains Software, then Navision... Read More
One day, you suddenly realize that your computer started to... Read More
Google Inc. has launched a new software package that allows... Read More
There are many commands that are used in linux on... Read More
Spyware is like the new technological nuclear weapon on the... Read More
Homeland security, airport security, Internet security â?" these days weâ??re... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
Some companies that are in need of fleet management may... Read More
When you own a small business, time is money. And... Read More
Writing software manuals is boring, isn't it? We often think:... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
Microsoft Great Plains is becoming more and more popular and... Read More
Google Inc. has launched a new software package that allows... Read More
One day, you suddenly realize that your computer started to... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
2005 ? Back to the Future.What does the future hold?... Read More
I have recently created my first Php program. I wanted... Read More
It's all about turn times in the eMedia industry! The... Read More
The major reason I recommend getting your hands on real... Read More
Microsoft Business Solutions is now in process of creating so... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
Let's first look at your ERP system selection (without Retail... Read More
We will base our prognosis on our Microsoft Business Solutions... Read More
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
For a long time now Microsoft's Internet Explorer has ruled... Read More
The purpose of one of our projects was MS Exchange... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
Have you ever noticed that when you look at your... Read More
Microsoft Outlook is one of the most widely used software... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
During the years of our consulting practice, which comes back... Read More
This article will not attempt to advocate the use of... Read More
There are plenty of articles out there about how to... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
For those who still don't know, Microsoft Publisher helps computer... Read More
Whether you need to close a sale, gather end-user feedback,... Read More
Software |