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.
In Table Properties, select the Filtering page.
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.
In the Operation drop-down list, select Equals.
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.
Enter the required value.
|
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. |
|
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
Click OK to confirm the settings.
The table in the generated report now contains only the data that passed the filter condition.