Recently, I wrote an APEX application for a department in the company. They want to put more than 100 columns on Excle (too wide ?) The table is displayed on InteractiveReport of APEX. More than that, the number of records to be displayed on each page should be as many as 250 rows (too long ?). This implementation is not difficult, but there is a problem that when users are reading data, the header often runs out of the screen. Body
Recently, I wrote an APEX application for a department in the company. They want to put more than 100 columns on Excle (too wide ?) The table is displayed on the Interactive Report of APEX. More than that, the number of records to be displayed on each page should be as many as 250 rows (too long ?). This implementation is not difficult, but there is a problem that when users are reading data, the header often runs out of the screen. Body
Recently, I wrote an APEX application for a department in the company.
They want to put more than 100 columns on Excle (too wide ?) The table is displayed on the Interactive Report of APEX.
More than that, the number of records to be displayed on each page should be as many as 250 rows (too long ?).
This implementation is not difficult, but there is a problem that when users are reading data, the header often runs out of the screen. It is inconvenient to start from another location.
It is a pity that the image can be separated as in Excel. So I came upCopy the header information and insert it into the desired locationThis stupid trick.
In fact, it is also simple. Double-click (DoubleClick) as needed and copy the header (the red part in the table below ).
Press (x) to delete the copied header. Press (+) to display the row data vertically. If IE is used, copy the data to the Clipboard.
ABC |
DEF |
GHI |
JKL |
..... |
... |
... |
XYZ |
... |
... |
123 |
456 |
789 |
012 |
.... |
... |
... |
999 |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
(Double |
Insert |
Inbound |
Table |
Header) |
|
|
|
|
|
ABC |
DEF |
GHI |
JKL |
... |
... |
... |
XYX |
... |
... |
987 |
123 |
445 |
768 |
.. |
... |
.. |
765 |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Screenshot:
Javascript code:
//**************************************
// Name: f104_insertheader.js
// Created by Cho for apex ir. 2011/11/20
// Added 1st line (Table Header) when double clicked.
// Tested OK under IE v7.0 and FF v8.0
//************************************** *
/************ Put following line (s) in IR Region Header HTML ******************
**************************************** ***************************************/
/*********** Put following line (s) in IR Region Footer HTML/Script ************
[Copy to Clipboard]
[Close x]
[X] copy finished.