Skip to Main Content
PLUG-INS
Long report into columns
Resizing dialog
Copy to clipboard
Time Touch Input
Restrict Shuttle
Copy Down
Store location
GENERATORS
Pipelined Function Generator
Generate substitution code
Generate getter and setter
Rewrite Query Parameters
Log statement
Align text on characters
Format APEX region source query
APEX EXAMPLES
Apex 5.0 Icons
Apex 5.1 Font Icons
Disabling items in tabular form
Usage Map
Excel Export
Introduction Report Subheaders plug-in
This dynamic action plug-in can be used to generate subheaders for an Apex Classic report.
Press Generate Subheaders to see the effect of this plug-in.
Check Repeat heading for headings after each subheader.
After developing and publishing this plug-in I found out that it reproduces standard Apex functionality of break columns
You can see the small differences below and read more about it
here
Info
Download from the plug-ins section of
apex.world
Supports both Apex 5.0 and 5.1.
More information in
this blogpost
Demo Report with plug-in
Generate subheaders
Repeat headings
Reset
Subheader
Empno
Ename
Job
Mgr
Hiredate
Sal
Comm
Deptno
department 10 - ACCOUNTING
7782
CLARK
MANAGER
7839
09-06-81
2450
-
10
department 10 - ACCOUNTING
7839
KING
PRESIDENT
-
17-11-81
5000
-
10
department 10 - ACCOUNTING
7934
MILLER
CLERK
7782
23-01-82
1300
-
10
department 20 - RESEARCH
7876
ADAMS
CLERK
7788
12-01-83
1100
-
20
department 20 - RESEARCH
7902
FORD
ANALYST
7566
03-12-81
3000
-
20
department 20 - RESEARCH
7566
JONES
MANAGER
7839
02-04-81
2975
-
20
department 20 - RESEARCH
7788
SCOTT
ANALYST
7566
09-12-82
3000
-
20
department 20 - RESEARCH
7369
SMITH23
CLERK
7902
17-12-80
800
-
20
department 30 - SALES1
7499
ALLEN
SALESMAN
7698
20-02-81
1600
300
30
department 30 - SALES1
7698
BLAKE
MANAGER
7839
01-05-81
2850
-
30
department 30 - SALES1
7900
JAMES
CLERK
7698
03-12-81
950
-
30
department 30 - SALES1
7654
MARTIN
SALESMAN
7698
28-09-81
1250
1400
30
department 30 - SALES1
7844
TURNER
SALESMAN
7698
08-09-81
1500
0
30
department 30 - SALES1
7521
WARD
SALESMAN
7698
22-02-81
1250
500
30
1 - 14
Demo Report - Native Apex
department 10 - ACCOUNTING
Empno
Ename
Job
Mgr
Hiredate
Sal
Comm
Deptno
7782
CLARK
MANAGER
7839
09-06-81
2450
-
10
7839
KING
PRESIDENT
-
17-11-81
5000
-
10
7934
MILLER
CLERK
7782
23-01-82
1300
-
10
department 20 - RESEARCH
Empno
Ename
Job
Mgr
Hiredate
Sal
Comm
Deptno
7876
ADAMS
CLERK
7788
12-01-83
1100
-
20
7902
FORD
ANALYST
7566
03-12-81
3000
-
20
7566
JONES
MANAGER
7839
02-04-81
2975
-
20
7788
SCOTT
ANALYST
7566
09-12-82
3000
-
20
7369
SMITH23
CLERK
7902
17-12-80
800
-
20
department 30 - SALES1
Empno
Ename
Job
Mgr
Hiredate
Sal
Comm
Deptno
7499
ALLEN
SALESMAN
7698
20-02-81
1600
300
30
7698
BLAKE
MANAGER
7839
01-05-81
2850
-
30
7900
JAMES
CLERK
7698
03-12-81
950
-
30
7654
MARTIN
SALESMAN
7698
28-09-81
1250
1400
30
7844
TURNER
SALESMAN
7698
08-09-81
1500
0
30
7521
WARD
SALESMAN
7698
22-02-81
1250
500
30
1 - 14