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 CRM Integration with Microsoft Retail Management System (RMS) ? Overview

Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More

Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager

As you probably know, when Microsoft purchased Great Plains Software... Read More

These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software

1. What determines the software price? Is it Per Seat... Read More

15 Questions to Ask Your Software Vendor

When making a decision to buy any piece of software... Read More

Software Process Improvement -A Successful Journey

Background: For many organizations like ours, the interim target of... Read More

Create A Flash Presentation For Free With Open Office

The intentions of this short tutorial are not to teach... Read More

Groupware: What Works the Way Businesses Do?

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

A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

Icons are used everywhere; right from software applications, to internet... Read More

C++ Tutorials: 3, Program Flow (If, Else, While, For)

Program Flow is what you think it is. How the... Read More

Programming Environments And The Software Production Process

Introduction: The creating of a computer program involves a number... Read More

Best Spyware Removers

Finding the best spyware removers to detect and remove spyware... Read More

The Death of Windows

I have always regretted how Microsoft price gouges and rips... Read More

Linux Dual Boot-How To Format

Just the thought of a duel-boot scares many people away,... Read More

Microsoft CRM Customization: Integration with Third Party SQL Application/Database

Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More

Simple Solution for Php Includes - IFrames

I have recently created my first Php program. I wanted... Read More

How a Bug Challenges to a Software Professional

It is really interesting that a bug can create problem... Read More

OSI Layers Model

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

Microsoft CRM and No-Frills Cadillacs

In today's business world it's all but impossible to escape... Read More

Microsoft Great Plains e-Commerce ? additional considerations for programmer

Microsoft Great Plains, designed back in 1990th as database transferable... Read More

Need of Document Management System (DMS)

Document Management or Enterprise Information Management is perhaps one of... Read More

Microsoft CRM Data Import FAQ

Microsoft CRM has built-in conversion tool, however you should probably... Read More

Create ASP in Minutes

DBxtra goes ASPGetting to the information hidden within corporate databases... Read More

Getting Technical Support Help Online

Sometimes your PC will start acting strange for no apparent... Read More

A Time-Saving Programming Tactic that Doesn?t Work

Let's say that you have a software project that's under... Read More

My Experience - Making a Vision into Reality

Disclaimer: All the thoughts expressed are my views only! Your... Read More

Imagine if Everyone Working In Your Office Was In Synch?

Microsoft-Outlook is a pretty amazing program. So much more than... Read More

Microsoft Business Solutions - Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL

Microsoft bought Navision, Denmark based software development company, along with... Read More

RFID: Strengthen the Position for SAP; United States

SAP Inc., a global leader in client/server enterprise application software... Read More

10 Ways to Learn a Software

Following tips help you to learn a software in lesser... Read More

Microsoft Great Plains as ERP and Microsoft CRM as CRM

If you have Microsoft Great Plains and support it for... Read More

The Importance of Timely Timesheets

Whether you are a small consultancy firm, a medium sized... Read More

Four Easy Ways To Prevent Spyware

How would you like to prevent spyware and adware from... Read More

Do You Want Your Own Fully Programmable ERP? - Part 1

We are in a transition phase in the Managerial Administration... Read More