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
- If Filter Type is First or Last, you must specify a positive whole
number in the associated field. The number cannot exceed 64K in size.
- A matrix (cross-product) group cannot have a filter
on it.
- Records excluded from the group by filter are
not used in computations. If you want to use data in calculations but
not have it appear in the report output, use a Format trigger to restrict
what appears in the output.
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.
Copyright © 1984, 2005, Oracle. All rights reserved.