Group filters
Filters enable you to conditionally remove records selected by your queries. Groups can have two types of filters:
ü Reports Builder packaged filters:
1. First, to display only the first n records for the group (for example, the first 5 records)
2. Last, to display only the last n records for the group
ü User-created filters, using PL/SQL.
About group filters
A group filter determines which records to include in a group. You can use the packaged filters, First and Last, to display the first n or last n records for the group, or you can create your own filters using PL/SQL. You can access group filters from the Object Navigator, the Property Inspector (the PL/SQL Filter property), or the PL/SQL Editor.
The function must return a Boolean value (TRUE or FALSE). Depending on whether the function returns TRUE or FALSE, the current record is included or excluded from the report.