| |
| |
|
softwarecatch.com
|
|
|
|
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.
MORE RESOURCES:
Google News |
|
|
|
RELATED ARTICLES
SpyBot - Search and Destroy versus Microsoft AntiSpyware (Beta).... My personal experiences... Ok.. 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. Is Your Computer Sick? Viruses and spyware usually show up on your computer one of two ways.Either they invade your system with a frontal assault like the Huns attacking the Romans, or they sneak in a back door like a cat burglar. What is Fleet Maintenance Software? Simply put, fleet maintenance allows companies to monitor and maintain their fleets of commercial vehicles more efficiently.Fleet maintenance requires a great deal of organization and management skills. Anti-Spyware Protection - Holes in the Shining Armor Looking at all the ads which promise to get rid of all spy programs, one may wonder why there is still plenty of them everywhere and the situation is by no means getting better. So let me spoil the advertisers' mood and show some of the "holes" in the majority of software products we expect to protect our data. Microsoft Great Plains implementation: Restaurants Supply Chain Management Example Microsoft Great Plains serves majority of US based horizontal and vertical markets. Being relatively flexible and customizable - it can fit your specific business requirements with light or deep customization. Falling in Love With More Than One Screensaver: The Fun Part Having from five to ten and more favorite screensavers is cool. But how do you enjoy them all in a straightforward and convenient way? Draw the power you need from the little yet useful tools discussed in this article!As you remember, earlier in my article What to Do if You Fall in Love With More Than One Screensaver we discussed the standard way of switching between multiple screensavers. Microsoft CRM Integration With Microsoft Office Documents - Overview For System Integrator Microsoft CRM is CRM application, maintained and supported by Microsoft Business Solutions. Microsoft CRM utilizes majority of the Microsoft technologies: Windows Active Directory, SQL Server, MS Exchange, BizTalk (integration with MS Great Plains, and soon with Navision), Message Queuing, . An Easy Way to Deal with Email Viruses and Worms If you feel intimidated when someone tries to teach you something new on the computer, this article is for you!In the course of my career, I've worked with many people who I knew were smart but were convinced that they couldn't learn how to do new things on a computer. At some point, they'd convinced themselves that they weren't one of those "computer people". Microsoft Great Plains RW: Report Writer Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized). Great Plains Report Writer (RW) module allows for modification and creation of Great Plains reports to suit your business needs. An Introduction to .NET Framework .Net Framework is a platform or development environment to seamlessly create web-applications that are accessible through client machines from across the globe. A Simple Computer Software Definition What is Software?Software is a set of instruction written to interface between man and machine.Who writes this instructions?Programmers writes this instructions. Groupware as a Document Manager: Collaboration Series #3 This article is the third of a series of articles exploring specific aspects of groupware. The brief informational articles in this series discuss some of the technologies associated with groupware, as well as some of the characteristics of groupware. Is Software Tester a Most Infamous Person in a Software Project Team? The fact that a software tester is a most infamous person in a software project team has some grounds underneath it. This is because a software tester usually speaks of the bugs in the developer's code. Screenshots Vista Windows Features Additionally, Vista will include many other new features.Aero Vista will include a completely re-designed user interface, code-named Aero. Two Reasons to Use Timesheet Software This short paper will expand on two key reasons to move to a computerized timesheet system at your company. There are more than two reasons of course, but these will be expanded on at a later date. Groupware Finds Home in American Business: Collaboration Tool Analysis What is Groupware?Have you ever had to manage document collaboration in a hurry? No need to be ashamed if you said "yes." Virtually every American business has experienced moments of ad hoc team collaboration. Information Products: A Business Owners Best Friend We live in a post-industrial age where information is the coin of the realm. Knowledge is the most valuable asset that a business owns. Preventive Maintenance Software Companies Several software companies design programs for preventive maintenance. Most of the preventive maintenance software companies produce programs for facilities and businesses. CRM 101: Customer Relationship Management for Beginners Customer Relationship Management, abbreviated "CRM," is the term for a business strategy that is designed to improve customer service. CRM is also designed to increase customer satisfaction and gain new customers, thus increasing a business' revenue.
|
|
Powered By: Free Work At Home Business Opportunity! |
| © 2006 |
