You can set chosen expression items thanks to filters, which are put on expressions. First you have to create a condition to have the possibility to put a filter. All positions without not meeting the condition will be removed.
put cursor in the listing, from which you want to remove chosen items by adding a filter
choose Filter from popup menu
or choose from menu
>from list
select expression to put a filter onselect button
In the area Chosen filters you will see a new filter
select from a drop down list the type of a condition ( list content is different for each kind of data - text, data, number, etc.)
select from the list the way of giving condition value:
manually
from
the list of accessible values
from
the list of report parameters
using
an expression
set condition value as presented in previous section
( to give expressions you can use expression creator
)
put cursor in the listing, where you want to remove a filter
choose
from popup menuor choose from menu
>you will see window Filter
Click on on the left
side of the filter, which you want to remove
set cursor on expression, on which you want put a filter
choose
from popup menuor choose from menu
>you will see window Filter with a new filter in field Chosen filter
compose a condition similarly as in user guide points 5-7; how to add a filter
Filtering with help of condition where, is an option only for advanced users.
It answers on SQL query select columns from table where condition type
select column of a listing, which you want to filter
On the formula bar replace an inscription [*table] : "true" with where( table condition): "true", where a condition is a written expression