You can use a variable or parameter as the test value in a filter condition. The user of the Worksheet (including users of linked Viewsheets and reports) will be prompted at runtime to enter the value of the parameter.
To use a variable or parameter in a filter condition, follow these steps:
The user is prompted for Variables and parameters in the same manner. However, Variables provide additional control over the interface (radio button, menu, etc.) and the set of choices presented to the user.
You can use table values as the test values in a filter condition. That is, you can define a filter condition that compares two values in the same row of the table.
To use a table field in a filter condition, follow these steps:
The condition compares corresponding values in the selected columns (left-most menu and right-most menu), and preserves only rows where the condition is met.
Copyright © 2023, InetSoft Technology Corp.