Filter a table

If you want to create a table that shows only specific data, you need to filter the table accordingly. This procedure shows you how to filter for a sample name, sample type, or compound name.

1. In Table Properties, select the Filtering page.

2. In the Expression drop-down list, select the data field that you want to use for filtering:

   • Fields  > Sample  > NAME if you want to filter for a specific sample name

   • Fields  > Sample  > TYPE if you want to filter for a specific sample type

   • Fields  > Compound  > NAME if you want to filter for a specific compound name

   The correct name of the respective data field is shown with an equals sign in front of it. For example: =Sample_Name.

3. In the Operation drop-down list, select Equals.

4. Select the Value field.

   If you start typing, you replace the entire existing content of the field. If you press F2, the cursor is shown, and you can edit the existing content.

5. Enter the required value.

   NOTE

   In the Value field, always start with an Equals sign (=). Text strings must be enclosed in quotes to be recognized as text. Numbers are written without quotes.

   NOTE

   If you filter for an enumeration, you must enter the required number in the Value field. See Enumerations for an overview of all enumerations.

   For example:

   • ="Standard L1" as a sample name

   • =1 as a sample type, in this case the calibration samples

   • ="TRAMADOL" as a compound name

6. Click OK to confirm the settings.

   The table in the generated report now contains only the data that passed the filter condition.