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".
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.