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.
|
|
|
Great Plains Customization Upgrade? Overview For Cio/it Director
Around the same time Microsoft made its move with .Net introduction and tried to gain portion of cheaper databases market: Pervasive SQL/Btrieve, Ctree/Faircom - and launched free MSDE database program. General direction for all its accounting systems was chosen - Microsoft announced future releases of so called Microsoft suites: Microsoft Financial, Microsoft HR, Microsoft Logistics, Microsoft Manufacturing to name a few. However Microsoft did not announce which product (Great Plains, Solomon or Navision) will become the base or will be transformed into each spe...(related: Software)
Spyware - The Internet Devil Of Our Times!
Spyware and Adware infest over 90 percent of computers in use today. Internet linked computers has made it easy for spybots, adware, and trojans to infiltrate and compromise online privacy. Installed toolbars can also contribute to browser hijacking and spyware related problems.Spyware, malware, scumware, and trojans gather information about people and online activities. It is important to deny these "Internet Pests" the opportunity to infiltrate computers, so that computer privacy is intact. Everybody is entitled to enjoy online privacy and security.There are serious consequences pertaining to unidentified spyware, which include identity...(related: Software)
Helpdesk & Asset Management Software - Choosing The Right One
If you are to buy a HelpDesk & Asset Management software, see the following checklist before you decide on one.Comprehensive Help Desk FunctionalityA good Help Desk product can dramatically rise the productivity of the Help Desk Personnel (which in turn will rise the organisation's productivity as a whole). Computer users can be made to submit their requests by mail, phone or through the web interface provided by the product. These requests gathered centrally will be attended to by technicians (who already are automatically notified about the request). Adding memos/notes to the requests & viewing the history of Requests can help too.Buildable Knowledge Base (KB)<...(related: Software)
Windows X: Basic Windows ?security? Issues
Language development computer:Computer-based method for aiding language development seems like an interesting idea, the trick with this would be in getting the computer to take on part of the role of the human in the checking process.In all computer aided learning applications aimed at the very young, there is a danger that the computer may be seen as a replacement for a human instructor, however computer are notorious for not volunteering information or inabilit...(related: Software)
Msn Messenger Is A Sweet Way To Communicate
MSN messenger is a pretty cool invention. I mean I'm not really into serious discussions on the email, answers to questions can often take a few days to arrive because people are so busy these days. I've just been 'hooked up' into Messenger and it's really a different kind of communication, quick, simplistic and even humorous with the capability to express your feelings with 'emotion' cartoons.With Messenger you can communicate with a group of close friends or business...(related: Software)
Destination: Desktop For Google
First we had the original Google search that evolved into the leader in its class. In fact, it became so popular ...(related: Software)
Microsoft Business Solutions Products Selection: Erp, Crm, Retail Management
Let's first look at your ERP system selection (without Retail Solution). Your options are:Microsoft Great Plains. If you remember successful mid-size application ? Great Plains Dynamics, pioneered on Mac and Windows graphical platforms in the mid 1990th. This is now...(related: Software)
Microsoft Rms Customization ? Po Items Receiving In Great Plains
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail and accounting/ERP solutions coming from the same Microsoft subdivision ? Microsoft Business Solutions. There is often common need to do integration between the two. Despite the fact that both systems come from the same software development company ? the integration is not as simple as it probably should be.In each case you have to use set of new Microsoft technologies: web service, SQL stored procs, C#, VB.Net programming, etc. In this small article we give you customization overview when you receive Purchase Order Receivings in Great Plains and automatically transfer them to the RMS ...(related: Software)
Microsoft Great Plains: Government & Non-profit Organization ? Workflow Implementation
Usually workflow & messaging is realized in CRM and then transactions are just logged into Accounting/ERP/MRP. In the case of Microsoft Business Solutions products: Microsoft Great Plains, Navision, Solomon, Axapta the natural CRM choice would be Microsoft CRM. However typical CRM application targets Sales automation, wh...(related: Software)
Accounts Payable: A Powerful Document Management And Workflow Solution
Accounts payable is just one area of office management where problems arise because of the sheer complexity of transactions, and the vast amount of paperwork that is generated.A disproportionate amount of time and administrative resources is consumed just getting invoices approved for payment. The problem becomes compounded when invoices are lost when being circulated for clearance and even more time is then lost in the retrieval process.Typically these documents include purchase invoices from suppliers, sales invoices to customers and purchase orders generated by customers.Even if missing documentation is successfully recovered from the system, the delay will have caused major inconvenience. If it is not recovered, the effects on business are routinely disruptive, and in extreme cases, disastrous.To...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software