Some data fields contain specific numbers that stand for certain values. These enumerations typically represent all data that is shown in a drop-down list in your chromatography data system.
If you add an enumaration data field by dragging it from the Report Items browser > Fields node to the report template, the application automatically creates an expression to show the text value corresponding to the stored number. Also if you use the prepared table or matrix snippets, they show the corresponding text.
If you add the database field directly in the Expression Editor, use the Choose function to show the text value (see Program Flow). For example:
=Choose(First(CalibCurve_Origin )+1 , "Ignore", "Include", "Force", "Connect")
Note that the first argument is addressed with the number "1", not with "0".
In the Custom Calculation Editor, expressions are built slightly different. To show text values of enumerations, use the ToString() function instead instead of the Choose function. See Enumerations in the Custom Calculator help. |
If you want to filter for a specific value of an enumeration, you must enter the correct number in the Value field. The following sections you find the text list values and corresponding numbers of all enumerations.