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.

---

Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer

... Read More

How the Firefox: How to... Manual Helped Me

A few months back I really got sick of my... Read More

Microsoft CRM Integration with Lotus Notes Domino: Messaging Connector ? Future Directions

IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More

What is Shareware?

Shareware is software that you can try before you buy;... Read More

Five Tips For A Great Software Demo

Whether you need to close a sale, gather end-user feedback,... Read More

Microsoft Great Plains PM: Payables Management

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Microsoft Moves to Small Business Accounting/Retail Market ? Stakes and Thoughts

In this small article we will be looking at the... Read More

Collaboration Software: Index of Collaboration Software Technologies

Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More

Lotus Domino Implementation and Development: Infrastructure ? Present and Future

Domino server is a buffer between the operation system and... Read More

C++ Function Templates

C++ Function templates are those functions which can handle different... Read More

Benefits of Shareware

Shareware has been fighting the stigma of being misunderstood for... Read More

Snort for Network IDS

What is Snort?Snort is an open source network intrusion detection... Read More

Microsoft Great Plains eCommerce: overview for developer

Microsoft Business Solutions Great Plains was designed back in the... Read More

It?s Back!! WordPerfect?s Amazing Comeback

Have you noticed WordPerfect is gearing up for a comeback... Read More

Groupware: What Works the Way Businesses Do?

GroupwareThe internet is full of 1.5 million to 7 million... Read More

Business Plan Software Review: Ultimate Business Planner?

One of the main reasons business owners and entrepreneurs use... Read More

Think Of This

Think of this, first we had the HAM Radio, then... Read More

Internet Security Threats: Who Can Read Your Email?

Before being able to choose a secure Internet communication system,... Read More

Microsoft RMS Customization ? PO Items Receiving in Great Plains

Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More

International Support - Microsoft Great Plains VAR/Partner Selection ? Overview for V.P. IT

Looks like Microsoft Great Plains becomes more and more popular,... Read More

Online PowerPoint Presentation ? Convert PowerPoint to Flash

Although we don't know whether Microsoft ever envisioned such a... Read More

Microsoft Great Plains: If You are Orphan Client ? What to Do and FAQ

Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More

Running a Program on a Remote Server Using SSH

How do you run a program on a remote server... Read More

Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains

We would like first emphasize the change in the paradigm.... Read More

DVD Burning Tips

CD and DVD replication is a process that works by... Read More

Great Plains Bill of Materials Setup & Customization for Process Manufacturing ? Overview

Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More

OSI Layers Model

IntroductionDuring the early years of our modern computer era, very... Read More

You Can Write Microsoft Office Program in About 60 Minutes

Microsoft Office program is a programming tool called Visual Basic... Read More

Free Preventive Maintenance Software

While several preventive maintenance software manufacturers offer free trials for... Read More

Corporate ERP Selection: Microsoft Great Plains

In our opinion, traditional approach when you select ERP/MRP system... Read More

What is Groupware?

Vince Lombardi once said that, "The achievements of an organization... Read More

MCP Market News: Microsoft SQL Server & SQL Reporting Services

Are you ready? SQL Server 2005, the next-generation data management... Read More

Microsoft Great Plains Partner Selection: Overview

Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business... Read More