Reports are used to export items (e.g., tokens, pictures) into Excel, Word or as Text/PDF files. All reports can contain tokens, and Word/Excel reports can also contain images. Exporting items using Reports is a two-step process:

 

1. Add the Report type to the Batch Actions list by selecting it from the Add Report section of the Batch Actions and Reports window. A properties dialog for that report type will appear. Once the properties are set, the report will be added to the list of Batch Process Actions.

2. Add the item(s) to be exported to the appropriate Report process.

 

 

There are different types of reports:

 

•Export to Luma (all items; please refer to the items listed below)

•Export to Spreadsheet (text)

•Prism XY Table (text)

•Prism Column Table (text)

•Prism Grouped Table (text)

•Excel (Column Mode) (text)

•Excel (Cell Mode) (text and images)

•Word Report (text and images)

•PDF form (text)

•Text Report (text)

 

 

 

The items which can be exported to a report are determined by the report type. Depending on the report type, the following items may be available:

 

•Regular Token (all available tokens, including Custom tokens)

•Statistic Token

•Keyword Token

•Picture (a plot in the layout, or an entire page of the layout, only used in Word, Excel-Cell Mode, and DDS reports)

•Text Box (text in a text box (e.g., canned comments) can be exported to a column in an Excel worksheet or other location)

•Gating ML

•PDF

•Layout

•PowerPoint

•FCS File

 

An example of the Batch Process Actions for an Excel (Cell Mode) report is shown in Figure 8.23.

 

 

 

 

This report will export two statistics and a picture of a specified plot for each iteration of the batch process. Only items that are checked will be exported.

 

Using the check boxes for each of the Batch Process Actions, an item can be enabled or disabled to run with the Batch Process. If you double click on the Batch Process Action (or right-click and choose Properties from the pop-up menu), you can navigate to the Running Options page of the Options dialog to control the activation state of an action (Figure 8.24). If you choose the Set the check box from the value of the expression below radio button, you can input a formula (using standard or custom tokens) to control the action.