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
Cambrault(148)
King(100)
Employees drilldown report
Employee Id
First Name
Last Name
Email
Phone Number
Hire Date
Job Id
Salary
Commission Pct
Manager Id
Department Id
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
114
Den
Raphaely
DRAPHEAL
515.127.4561
07-DEC-94
PU_MAN
11000
100
30
120
Matthew
Weiss
MWEISS
650.123.1234
18-JUL-96
ST_MAN
8000
100
50
121
Adam
Fripp
AFRIPP
650.123.2234
10-APR-97
ST_MAN
8200
100
50
122
Payam
Kaufling
PKAUFLIN
650.123.3234
01-MAY-95
ST_MAN
7900
100
50
123
Shanta
Vollman
SVOLLMAN
650.123.4234
10-OCT-97
ST_MAN
6500
100
50
124
Kevin
Mourgos
KMOURGOS
650.123.5234
16-NOV-99
ST_MAN
5800
100
50
145
John
Russell
JRUSSEL
011.44.1344.429268
01-OCT-96
SA_MAN
14000
.4
100
80
146
Karen
Partners
KPARTNER
011.44.1344.467268
05-JAN-97
SA_MAN
13500
.3
100
80
147
Alberto
Errazuriz
AERRAZUR
011.44.1344.429278
10-MAR-97
SA_MAN
12000
.3
100
80
148
Gerald
Cambrault
GCAMBRAU
011.44.1344.619268
15-OCT-99
SA_MAN
11000
.3
100
80
149
Eleni
Zlotkey
EZLOTKEY
011.44.1344.429018
29-JAN-00
SA_MAN
10500
.2
100
80
201
Michael
Hartstein
MHARTSTE
515.123.5555
17-FEB-96
MK_MAN
13000
100
20
Spread Sheet
1 - 14