>> Update My Profile | Subscribe to Access Agilent | Article Directory

Agilent’s OpenLAB Intelligence Reporter:
new revision makes complex reporting even easier

By Christoph Nickel
Agilent Chromatography Data Systems Marketing Manager

Reporting – a key bottleneck in the analytical laboratory

Reporting is a critical factor for improved productivity in pharmaceutical and chemical laboratories. Analytical reports from chromatographic data systems often do not allow you to include all the necessary data and calculations, or to represent results in the right format. You frequently need to rework reports or even transfer results into other applications to perform calculations or to generate the final report for the batch, experiment, or study. Agilent OpenLAB Intelligence Reporter helps lab technicians and lab managers to overcome this bottleneck. It is a powerful reporting package for chromatographic data managed in Agilent OpenLAB Enterprise Content Manager (ECM).

Figure 1. This report from OpenLAB Intelligence Reporter gives the percentage of drug dissolution for each time point and vessel, summarizing data from many sample analyses into a single final report. (Click here to see this image larger.)

Figure 2. Reports can include calculations of final results and color-coded flags of limit violations, as shown in this report for refinery gas analysis. (Click here to see this image larger.)

Faster reports – with exactly the information you need

When you need configurable final reports that meet regulatory guidelines and include advanced calculations, Agilent OpenLAB Intelligence Reporter is the solution. Creating your reports is very easy and intuitive with Agilent’s new easy-to-use, graphical Report Template Editor. Start with built-in templates and modify them to match your specific needs. For more advanced reports (for example, those with multiple levels of calculations), you use Microsoft’s Business Intelligence Development Studio to modify the template. You can use this tool because the Agilent OpenLAB Intelligence Reporter is built on industry standards. It uses the Microsoft SQL Server as a relational reporting database and Microsoft’s Report Definition Language (RDL) to define the report template format.

OpenLAB Intelligence Reporter delivers:

• Flexible, user-defined report template generation
• Lab-wide reporting across sequences and even across instruments
• Simple and advanced custom calculations
• Sorting, filtering, or grouping on any data field from the database
• Interactive or “intelligent” reporting of results; for example, color-coding of outliers and limit violations
• Easy interfacing to other reporting applications through published and documented database views

The new revision 2 of OpenLAB Intelligence Reporter, released in August 2009, provides enhanced usability and expanded functionality. Revision 2 features an intuitive graphical drag-and-drop method to design report templates. The package also supports complete single-injection and sequence-summary reports, including chromatograms, spectra and calibration curves.

OpenLAB Intelligence Reporter meets your most complex reporting demands, saving time and avoiding the inevitable mistakes that arise from manual data transfer. You can apply the software to many types of pharmaceutical and chemical analyses – or even use it to track usage of instruments in your lab. Applications include:

• Dissolution testing
• Refinery gas analysis
• Impurity profiling
• System suitability reports
• Lab asset reporting such as instrument or column utilization

Agilent OpenLAB Intelligence Reporter helps you create complex final reports directly from chromatographic data stored in Agilent OpenLAB ECM. You can create exactly the reports you need – quickly and with accurate results. To learn more about Agilent OpenLAB Intelligence Reporter, please visit our product page.

>> Update My Profile | Subscribe to Access Agilent | Article Directory