Explanations of pages in this application
1.
Explanation of Dynamic Breadcrumbs page
2.
Explanation of Data Densification page
3.
Explanation of ReForms in APEX page
4.
Explanation of Matrix reports page
This application is based on the discussions in the
sample chapter
of
Oracle APEX 4.2 Reporting Book
Vishal's blog
Dynamic Breadcrumbs
Data Densification
ReForms in APEX
Matrix reports
All employees
Employees drilldown report
Employee Id
First Name
Last Name
Email
Phone Number
Hire Date
Job Id
Salary
Commission Pct
Manager Id
Department Id
100
Steven
King
SKING
515.123.4567
17-JUN-87
AD_PRES
24000
148
90
101
Neena
Kochhar
NKOCHHAR
515.123.4568
21-SEP-89
AD_VP
17000
100
90
102
Lex
De Haan
LDEHAAN
515.123.4569
13-JAN-93
AD_VP
17000
100
90
103
Alexander
Hunold
AHUNOLD
590.423.4567
03-JAN-90
IT_PROG
9000
102
60
104
Bruce
Ernst
BERNST
590.423.4568
21-MAY-91
IT_PROG
6000
103
60
105
David
Austin
DAUSTIN
590.423.4569
25-JUN-97
IT_PROG
4800
103
60
106
Valli
Pataballa
VPATABAL
590.423.4560
05-FEB-98
IT_PROG
4800
103
60
107
Diana
Lorentz
DLORENTZ
590.423.5567
07-FEB-99
IT_PROG
4200
103
60
108
Nancy
Greenberg
NGREENBE
515.124.4569
17-AUG-94
FI_MGR
12000
101
100
109
Daniel
Faviet
DFAVIET
515.124.4169
16-AUG-94
FI_ACCOUNT
9000
108
100
110
John
Chen
JCHEN
515.124.4269
28-SEP-97
FI_ACCOUNT
8200
108
100
111
Ismael
Sciarra
ISCIARRA
515.124.4369
30-SEP-97
FI_ACCOUNT
7700
108
100
112
Jose
Urman
JMURMAN
515.124.4469
07-MAR-98
FI_ACCOUNT
7800
108
100
113
Luis
Popp
LPOPP
515.124.4567
07-DEC-99
FI_ACCOUNT
6900
108
100
114
Den
Raphaely
DRAPHEAL
515.127.4561
07-DEC-94
PU_MAN
11000
100
30
Spread Sheet
Select Pagination
row(s) 1 - 15 of 107
16 - 30 of 107
31 - 45 of 107
46 - 60 of 107
61 - 75 of 107
76 - 90 of 107
91 - 105 of 107
106 - 107 of 107
Next