Page 1 of 1

Course OpenLAB Chromatography Data System

Posted: Tue Mar 15, 2016 2:58 pm
by JvE010
I'm looking for some seminars on OpenLAB Chromatography Data System data processing. More specifically the intelligent reporting function.

I've found this but I'd prefer some real seminars instead of eSeminars, preferably in the west-European region.

Re: Course OpenLAB Chromatography Data System

Posted: Mon Mar 28, 2016 8:22 pm
by bundy5555
Sadly, there is no good e-seminar for Intelligent Report. Those are very very very basic tutorials. Learn it through user manuals.

Usually..

For a beginner, I recommend these three manuals from Agilent

1) Manual for Advanced Report Template Designers
2) Agilent OpenLAB Report Template Editor - Concepts Guide
3) Report Template Editor - Concepts Guide

The first manual is focused on OpenLab with ECM option. Probably not what you are looking for.

The other two are for Openlab without ECM. There are allot of overlaps between these two manuals. So you can choose any one of these two.

It is very important to understand that Intelligent Report Template is written in Microsoft Report Definition Language 2005 (RDL 2005). Intelligent Report Editor in Openlab is a "Lite" version of Report Editor for MS SQL 2005 Reporting Service. Many functions that available in MS SQL 2005 Reporting Editor are not available in the OpenLab Intelligent Report Editor, but it can be used through editing the source code using any text editor (*.RDL file). I strongly recommend you to learn some Microsoft Report Definition Language 2005 schema on how template is structured as code. This way you can achieve the full potential of the Intelligent Reporter.

From my working experience, Intelligent Report Editor works poorly when you have allot of custom/conditional calculations, result summarization, matrix and formatting. In order to achieve a professional result, you need to know template structure in RDL 2005 Schema.

If you want to go deep, the next step would be take some courses on Microsoft SQL Reporting Service. But remember, Agilent OpenLab Intelligent Reporter still use the old RDL 2005. It is quite different than RDL 2008 R2 and onward.