Layout Filters

Filters apply to the Layout rows and allow defining sorting filtering conditions.

The left window lists the data blocks of the Layout. To define sorting or to define a filter, click on the desired block then drag and drop it to the Sort by field or to a Filter field as shown.

when two filtering conditions are defined, they can be combined using the logical operations :

 

The Keep top option allows to display a given number of rows. For example Keep top 10 will only display the first 10 rows.

The Keep Totals option shows the total of the visible rows only. For example activating this option on a layout having Keep top 10, will show as column total the total of the top 10 rows only. If this option is disabled, the column total will be the grand-total of all report rows, calculated before filtering the unwanted rows.

 

Note:

If the Layout has one or more entities set by column, sorting is evaluated on the row total column.