As a Notes/ Domino developer, you must be familiar with the limitations of reporting from Notes and Domino data. Common approaches include using Notes scripting or external reporting tools to transform the data into meaningful reports that can be accessed on demand by end users.
This section provides a quick overview of the two methods, their inherent limitations, and provides an introduction to IntelliPRINT, the only effective reporting solution that is native to Notes and Domino. The section on IntelliPRINT lists a few of its key features, which make it an effective solution for addressing the need for reporting from Notes and Domino data in a holistic manner.
There are two common approaches generally followed by organizations to report and print data from Notes and Domino.
Notes professionals often prefer to create and manage their reports programmatically using LotusScript. This approach ensures that data security and integrity is preserved, the business context is inherited, and the Notes application workflow is kept intact. While it overcomes many limitations set by non-native reporting tools, reporting using LotusScript does have a few limitations:
This approach is time consuming, expensive, and end user unfriendly. In most situations, user requests for reports cannot be met due to the effort involved in producing the report and the poor presentation quality of the reports.
There are a wide variety of report creation tools with extensive functionality that are available for use with Notes and Domino. However, most of these are not native to the Notes and Domino framework. These tools connect to Notes data by using ODBC drivers or by exporting Notes data to other formats such as spreadsheets. Limitations posed by these approaches include:
IntelliPRINT started as a printing solution for Notes and Domino and has matured to become one of the best reporting solutions in its current release, which was launched at Lotusphere 2007. It has also been extended to natively support Notes/ Domino 8 while continuing support for Notes versions 6 and 7.
IntelliPRINT Reporting is to Notes and Domino what Crystal Reports is to Visual Basic. It is a native reporting component that is tightly integrated with the Notes and Domino application framework. It is a logical extension to Notes and Domino and lets you use its APIs to tightly integrate the reports within the workflow of your Notes and Domino applications.
As the report format is stored as a Notes document, security settings for report access as well as row-level access are automatically inherited from the Notes ACL. The report is then presented as a Notes tab, making the reporting workflow integral to your application workflow.
The key features that make it a logical extension of Notes and Domino are listed below and include details of the steps involved in creating a simple report and a complex report.
Consider a scenario where a multi-level cross-tab report has to be created, such as a sales report that shows the sales for multiple products across several geographical regions. The rows would display the sales for each of the regions while the columns would show the product sales across the regions. Creating such a cross-tab by just using LotusScript would typically entail the following:
The same cross-tab can be created with IntelliPRINT Reporting within just a few minutes. The benefits of using IntelliPRINT in this situation include:
IntelliPRINT thus helps reduce a substantial amount of IT workload for not only creation of the report but also for future changes in the report! The report format gets saved in the host database and can be accessed on demand by authorized users.
Once designed, a report template is stored in the host Notes application or a central report repository. These formats can also be deployed on a Domino server and made available online via a web browser. Report format take very little space to store - typically less than 100 KB, and can be opened almost instantaneously.
When a report is viewed, data is fetched from the database and presented in the format as specified in the report metadata. This ensures the report always reflects real-time information. Generated reports can be programmatically stored; for example you could save them into the same Notes database as the application.
IntelliPRINT Reporting integrates seamlessly with the Notes and Domino's existing security framework. Reports are only accessible to users who have access to the applications in which IntelliPRINT is embedded. In addition, report creators can specify access controls for individual reports in addition to the Notes ACLs already present. This means the data in IntelliPRINT reports have access controls enabled for users as well as groups. Report designers can easily set this up using a form, which will specify access levels for each report. This ensures that your users can access their data within Notes' secure, consistent security model without you having to spend time and effort to set up different systems.
Report templates that have been embedded in the Notes application can be made available to users by just adding action buttons in the Notes application. Consider the scenario where an employee needs to create timesheet reports from an HR application. Using IntelliPRINT, the reports can be triggered by "action" buttons within the application, and directly mailed to users as PDF attachments.
The entire process can be automated on a Domino server using Notes agents that can generate reports automatically at predefined intervals, for example, weekly reports that are generated every Monday. The agent will also handle e-mailing of these reports to the users.
Automation of the entire reporting system for scheduled reporting provides tremendous benefits to IT personnel as well as the business users. IT no longer needs to spend days working on manual report creation and business users are guaranteed timely delivery of reports.
With IntelliPRINT Reporting, simple tabular reports can be created in a matter of minutes. The procedure below describes the steps involved in creating a simple report. The steps below are to be performed on the Pinnacle Electronics sample database provided with IntelliPRINT Reporting. The database is automatically installed while installing IntelliPRINT Reporting.
To create a simple report using a wizard, do the following:
And you're report is ready; the Wizard will now place the bands automatically. Click the Preview button to view the final report. You can even adjust the band layout to suit your needs. The entire process takes just a few minutes!
IntelliPRINT Reporting allows you to create a variety of complex reports such as:
Here we will step through the procedure for creating a master-detail report. We'll be working with the Pinnacle Electronics sample database that is provided with IntelliPRINT Reporting.
A master-detail report connects to a database using multiple queries. The idea is to extract related information from two different queries and print them in the same report. For instance, we can design a report which utilizes two queries - the first query fetches the customer Name and ID while the second query extracts the same customer's purchase details, such as the Product name, Quantity, and Unit price.
To create a master-detail report, do the following:
Your report is ready; click Preview to view it. To add even more power to your report, you can add objects such as computed columns, images, charts, cross-tab tables, rich text, subreport objects, and a lot more.
To sum up, here's why IntelliPRINT Reporting can help you improve the productivity of your reporting system:
All of these make IntelliPRINT Reporting the product of choice for reporting and printing with Lotus Notes and Domino applications.
For more information on IntelliPRINT, please visit http://www.synaptris.com/go/intelliprint.
52.14.175.148