OpenLAB CDS Report Template Editor

1 Agilent TechnologiesOpenLAB CDS Report Template EditorConcepts GuideConcepts GuideConcepts GuideNotices Agilent Technologies, Inc. 2009-2017No part of this manual may be reproduced in any form or by any means (including electronic storage and retrieval or transla-tion into a foreign language) without prior agreement and written consent from Agi-lent Technologies, Inc. as governed by United States and international copyright Part NumberM8305-90023 Edition09/2017 Printed in GermanyAgilent TechnologiesHewlett-Packard-Strasse 8 76337 WaldbronnWarrantyThe material contained in this docu-ment is provided as is, and is sub-ject to being changed, without notice, in future editions. Further, to the max-imum extent permitted by applicable law, Agilent disclaims all warranties, either express or implied, with regard to this manual and any information contained herein, including but not limited to the implied warranties of merchantability and fitness for a par-ticular purpose.

2 Agilent shall not be liable for errors or for incidental or consequential damages in connection with the furnishing, use, or perfor-mance of this document or of any information contained herein. Should Agilent and the user have a separate written agreement with warranty terms covering the material in this document that conflict with these terms, the warranty terms in the sep-arate agreement shall Licenses The hardware and/or software described in this document are furnished under a license and may be used or copied only in accordance with the terms of such Rights LegendIf software is for use in the performance of a Government prime contract or sub-contract, Software is delivered and licensed as Commercial computer software as defined in DFAR (June 1995), or as a commercial item as defined in FAR (a) or as Restricted computer software as defined in FAR (June 1987) or any equivalent agency regu-lation or contract clause.

3 Use, duplication or disclosure of Software is subject to Agi-lent Technologies standard commercial license terms, and non-DOD Departments and Agencies of the Government will receive no greater than Restricted Rights as defined in FAR (c)(1-2) (June 1987). Government users will receive no greater than Limited Rights as defined in FAR (June 1987) or DFAR (b)(2) (November 1995), as applicable in any technical NoticesCAUTIONA CAUTION notice denotes a hazard. It calls attention to an operating procedure, practice, or the like that, if not correctly per-formed or adhered to, could result in damage to the product or loss of important data. Do not proceed beyond a CAUTION notice until the indicated condi-tions are fully understood and met. WARNINGA WARNING notice denotes a hazard. It calls attention to an operating procedure, practice, or the like that, if not correctly performed or adhered to, could result in personal injury or death.

4 Do not proceed beyond a WARNING notice until the indi-cated conditions are fully understood and RevisionThis guide is valid for revision of OpenLAB CDS ChemStation Guide3In This This guide contains information for Template developers. It describes the concepts and advanced features of the Report Template Editor (RTE).For information on basic tasks and the user interface please refer to the RTE online chapter provides an overview of the possibilities of the Report Template Text Fields and Data FieldsThis chapter describes the characteristics and usage of text fields and data fields in chapter describes the characteristics and usage of tables in chapter describes the characteristics and usage of matrices in Composite GroupsThis chapter describes the characteristics and usage of Composite Groups in chapter describes the characteristics and usage of images in ChromatogramsThis chapter describes the characteristics and usage of chromatograms in GuideIn This Calibration CurvesThis chapter describes the characteristics and usage of calibration curves in chapter describes the characteristics and usage of spectra in Mass Spectrometry Report ItemsThis chapter describes the

5 Characteristics and usage of Mass Spectrometry Report items in ChartsThis chapter describes the characteristics and usage of charts in Method InformationThis chapter describes the characteristics and usage of method information in RTE. 13 Other SnippetsThis chapter contains information on snippets that are based on previously described Report items, but preconfigured for specific ExpressionsThis chapter describes the characteristics and usage of expressions in Calculation VariablesThis chapter describes the characteristics and usage of calculation variables in Report Template Audit TrailThis chapter describes the Report Template Audit Trail in Guide5In This Report ParametersThis chapter describes the characteristics and usage of Report parameters in Advanced Report FeaturesThis chapter describes the characteristics and usage of advanced Report features such as document maps, locked Report items.

6 Or custom AppendixThis chapter contains a list of all operators and functions available in the Expression GuideContentsContents1 Overview 9 Overview10 Report Types12 Working With Templates132 Text Fields and Data Fields19 About Text Fields and Data Fields20 Using Fields233 Tables 25 About Tables26 Using Tables27 About Table Groups40 Using Table Groups42 About Custom Tables434 Matrices 45 About Matrices46 About Matrix Groups47 Using Matrices495 Composite Groups53 About Composite Groups54 Using Composite Groups566 Images 59 About Images60 Using Images60 Concepts Guide7 Contents7 Chromatograms61 About Chromatograms62 Using Chromatograms658 Calibration Curves73 About Calibration Curves74 Using Calibration Curves76To Show Disabled Calibration Points789 Spectra 79 About Spectra80 Using Spectra8210 Mass Spectrometry Report Items85 About Mass Spectra86 Using Mass Spectra8811 Charts91 About Charts92 Using Charts10012 Method Information105 About Method Information106To filter for a specific section107 Add a single method parameter108 Add tabular method information10913 Other Snippets111 Instrument Information11214 Expressions115 About Expressions116 Using Expressions1278 Concepts GuideContents15 Calculation Variables139 About Variables140 Using Variables14616 Report Template Audit Trail157 About the Report Template Audit Trail15817 Report Parameters159 About Report Parameters160 Using Report Parameters16118 Advanced Report Features167 Document Map168 Locked/Unlocked Report Items171 Custom Assemblies17319 Appendix175 Enumerations176 Keys in Diagnostic Data1839 Concepts GuideAgilent Technologies1 OverviewOverview10 Report Types12 Working With Templates13To Add and Configure Report Items13To Move or Resize Report Items13To A l i g n R e p o

7 R t I t e m s14To Change the Paper Size and Orientation17To Insert the Page Number18To Change the Font Properties for Multiple Report Items18To Add Items to the Header or Footer18 This chapter provides an overview of the possibilities of the Report Template Guide1 OverviewOverviewOverviewWith Reporting, the data you loaded for analyzing and reprocessing is automatically available for reporting. The Report Template Editor (RTE) helps you building new Report templates with your own Template layout, or editing existing ones, for example by adding complex provided by different applicationsYou can use Report templates in different applications, for example, in OpenLAB ECM Intelligent Reporter, OpenLAB CDS ChemStation, or OpenLAB CDS EZChrom edition. With Report templates, a user can create reports with a specific design, such as a sequence overview with a sequence table and statistics, or a cross-sequence summary.

8 The reports will contain the data selected in the current session of the respective featuresCreate different Report types such as single sample reports, sequence summary reports, or cross-sequence summary reports ( Report Types on page 12).Using Report parameters allows you to create dynamic reports that contain limited data as chosen by the user, such as all data for a specific month or year ( About Report Parameters on page 160).File format of Report templatesAll Report templates are based on the Report Definition Language (RDL), which is a standardized XML format provided by Microsoft .SnippetsThe Report Template Editor (RTE) provides various preconfigured Report items - also referred to as snippets - that you can use in your Guide11 Overview1 OverviewReport Template DocumentationReport Template Documentation Tool is a standalone application to view the description of the RTE supported Report templates.

9 It can also save this description in PDF format. The description about the Report Template includes layout of Report items along with their parameter details, such as calculation variables, Report parameters, expressions used, filter condition, sort condition, audit trail launch the Report Template Documentation Tool, run the file. By default, it is located in C:\Program Files (x86)\Agilent Technologies\ChemStation. When the application is launched, an Open dialog allows you to select a Report ItemsNOTEThe described Report items are a superset. Not all Report items are always available. The availability of Report items depends on the following: Type of the current Template (for example, Single Sequence Summary or Cross-Sequence Summary) Type and revision of the application Instrument module and driver version12 Concepts Guide1 OverviewReport TypesReport TypesEach Template is of a specific Report type.

10 Depending on this Report type, the Template is connected to a particular database view with the data organized in a specific following Report types are available: With Single Injection reports, RTE automatically creates a list of all injections in the current data scope. The generated Report then shows the Report items from the Template separately for each injection. Therefore, you do not need to worry about repeating composite groups on injection IDs. On the other hand, you cannot compare results from different injections in one table or example, the Report contains a sequence table. You selected 4 injections from 2 different sequences. The generated Report contains 4 separate tables, one for each injection. With Single Sequence Summary reports, RTE automatically creates a list of all sequences in the current data scope. The generated Report then shows the Report items from the Template separately for each of the sequences.