A script-enabled browser is required for this page to function properly.

Filter Type property

The Filter Type property specifies the type of filter Reports Builder should use on the records being fetched for the group.

Applies to

Groups

Values

None

You are not using a filter for the group.

First

The first n records retrieved should be included in the group, where n is a number specified in the Number of Records property.

Last

The last n records retrieved should be included in the group, where n is a number specified in the Number of Records property.

PL/SQL

A PL/SQL function for determining which records to include in the group will be defined (or referenced).

Default

None

Required/Optional

Optional

Restrictions

Example

Suppose that you have a group named EMP that contains two columns (ENAME and SAL). The parent group of EMP is DEPT, which contains one column (DEPTNO). You specify a Filter Type of First and Number of Records of 3 for DEPT and a Filter Type of First and Number of Records of 5 for EMP. This will return the first three department numbers retrieved by Reports Builder with the first five names and salaries retrieved for each department.