How to Add and Set Up a Report Line to the Sequence Table in OpenLab CDS

Answer

This Information Applies To: Agilent OpenLab CDS

Issue

This article will explain how to add a sequence summary report line to a sequence, in Agilent OpenLab CDS, as well as how to configure it so it matches your reporting needs.

Background

Adding a sequence summary report line to the sequence requires a basic understanding of sequences as well as how to submit runs and sequences within OpenLab CDS. For further detail on this subject, read the following article: How to create, edit and run a sequence in Agilent OpenLab CDS.

A sequence will not have a report line as a default, it must be added manually. For an example of how a simple sequence looks like, see Figure 1.

Figure 1. A simple setup for a sequence within OpenLab CDS.

Requirements

A report template needs to already have been created. If it is not, it must be created in Data Analysis. The user creating the report template requires the correct privilege (Role Membership): Data Processing > Print results reports. Privileges are assigned from the Control Panel of the OpenLab CDS Software. For further detail, read the following article: How to create or edit roles in OpenLab Chromatography Data System. 

If you plan on enabling automatic printing, you will need to add a default printer to the Instrument Controller. You can find this post Installation task in the OpenLab CDS Workstation Guide or OpenLab CDS Client and Instrument Controllers Guide, PDF manuals that are provided with the installation media.

Steps to Follow

1. Add a report line to the existing sequence (see Figure 1), by doing one of the following:
   
   • Click the drop-down menu indicated in Figure 2 and select Add a create report line to the end.
     

     
     
     Figure 2. One method of adding a report line at the end of a sequence table.

     
     
   • Right-click somewhere in the white space under the sequence table, then click Add a create report line to the end.
     

     
     Figure 3. Alternate method of adding a report line at the end of a sequence table.
     
     

     A report line was added, but it contains errors, indicated by the red margins (See Figure 4). The errors can be cleared when completing the required fields.

     
     
     Figure 4. Create Report line errors and where to fix them from.
     
     

2. Add a report template in the Template field:
   
   
   1. In the Create Report tab, click the drop-down list in the Template column.
      
      

      
      Figure 5. Template column drop-down list.
      
      

   2. Choose a report template from the list, or, click Browse to select more templates from the local drive.
      
      

      
      Figure 6. Template selection options
      1. Methods Lists, 2. Browse report templates.
      
      

      
      Figure 7. Select a report template window
      
      

3. Choose a Printer from the drop-down list.
   
   

   Caution: If you do not have a physical printer, you need to leave this blank. You can still create a PDF file, which does not require a physical printer.

    

4. Choose the File Format from the drop-down list.
   

   You can choose one or more file types, depending on what your reporting needs are. Options available are: CSV, Excel, PDF, text, and Word. (See Figure 8)

   
   
   Figure 8. File Format options
   
   

5. If the Label selection field is empty, the report will include all sequence lines. However, if you want to only include particular lines/sample/labels, you need to add them in the Label selection field.
   Choose the Labels that you want to include in the report, under the Label Selection column (Optional)
   Labels can be defined in the Sequence table, under the Labels column. (Figure 9)
   

   
   
   Figure 9. Location of where to define the Labels in the Sequence Table Label.
   
   

Add the name of the labels, separated by ";", with no space in-between. Figure 10 is an example of how to select two out of the six lines from the sequence in Figure 9.

Figure 10. Choosing to report a partial sequence table.

Tips: You can add multiple report lines. To add a second report configuration, right-click in the Create Report tab area, and click Add Report Configuration. (See Figure 11) Start over from step 1 to configure the new line.

Figure 11. Adding a new report line.

Confirmation: At this point, the report configuration is complete, and the sequence can be run. At the end of the sequence, all the requested report files will appear under the Results folder.

Learn how to effectively operate your Agilent OpenLab CDS Software: Agilent 8890 GC with OpenLab CDS Agilent 1260 Infinity LC Systems with OpenLab CDS