In the Hierarchy Build Wizard, in the Display Options step, you can specify a Type, Value Type, and Value combination to define the look and feel of the drill up and drill down links that the end user clicks to drill up or down in the hierarchy.
Literal Text Link |
Drill Up/Down Options |
|||
Note: A literal text link displays only when there is additional data to drill up or down to. In this example, there is no additional data for JONES, so there is no link. |
||||
|
|
Type |
Value Type |
Value |
Drill Up |
Text |
Literal |
Up |
|
Drill Down |
Text |
Literal |
Down |
In the Hierarchy Build Wizard, in the Display Options step, you can specify a Type, Value Type, and Value combination to define the look and feel of the drill up and drill down links that the end user clicks to drill up or down in the hierarchy.
Literal Text Link |
Drill Up/Down Options |
|||
Note: A literal text link displays only when there is additional data to drill up or down to. In this example, there is no additional data for JONES, so there is no link. |
||||
|
|
Type |
Value Type |
Value |
Drill Up |
Text |
Literal |
Up |
|
Drill Down |
Text |
Literal |
Down |
Column Expression Link |
Drill Up/Down Options |
|||
Note: A column expression link displays the column expression value even if there is no associated link. In this example, JONES displays with its associated JOB column expression (MANAGER), but this is not an active link as in the other elements of the hierarchy. |
||||
|
|
Type |
Value Type |
Value |
Drill Up |
Text |
Column |
'(' || JOB || ')' |
|
Drill Down |
Text |
Column |
'(' || JOB || ')' |
Button with a Literal Value |
Drill Up/Down Options |
|||
Note: A button with a literal value displays only when there is additional data to drill up or down to. In this example, there is no additional data for JONES, so there is no button displayed. |
||||
|
|
Type |
Value Type |
Value |
Drill Up |
Button |
Literal |
/\ |
|
Drill Down |
Button |
Literal |
\/ |
Button with Column Expression Value |
Drill Up/Down Options |
|||
Note: A button with column expression value displays the column expression even if there is no associated link. In this example, JONES displays with its associated JOB and DEPTNO information (MANAGER-20), but this is not an active link as in the other elements of the hierarchy. |
||||
|
|
Type |
Value Type |
Value |
Drill Up |
Button |
Column |
JOB || '-' || DEPTNO |
|
Drill Down |
Button |
Column |
JOB || '-' || DEPTNO |
Image Link |
Drill Up/Down Options |
|||
Note: When the Type is Image, the Value Type is ignored. The image file specified must be in the /images/ virtual directory of the listener. |
||||
|
|
Type |
Value Type |
Value
(click |
Drill Up |
Image |
N/A |
arrowu.gif |
|
Drill Down |
Image |
N/A |
arrowd.gif |