6.5. How to remove chosen listing items

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.

6.5.1. How to add a filter

  1. put cursor in the listing, from which you want to remove chosen items by adding a filter

  2. choose Filter from popup menu

    • or choose from menu Listing > Filter

  3. from list Chosen Filters select expression to put a filter on

  4. select button Add filter

    In the area Chosen filters you will see a new filter

  5. select from a drop down list the type of a condition ( list content is different for each kind of data - text, data, number, etc.)

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

  7. set condition value as presented in previous section ( to give expressions you can use expression creator )

6.5.2. How to remove a filter

  1. put cursor in the listing, where you want to remove a filter

  2. choose Filter from popup menu

    • or choose from menu Listing > Filter

    you will see window Filter

  3. Click on on the left side of the filter, which you want to remove

6.5.3. How to put a filter on chosen expression the fast way

  1. set cursor on expression, on which you want put a filter

  2. choose Expression filter from popup menu

    • or choose from menu Listing > Expression filter

    you will see window Filter with a new filter in field Chosen filter

  3. compose a condition similarly as in user guide points 5-7; how to add a filter

6.5.4. How to filter with using condition where

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

  1. select column of a listing, which you want to filter

  2. On the formula bar replace an inscription [*table] : "true" with where( table condition): "true", where a condition is a written expression