************************************************************

TIMING: 0.04 sec.
Shows the elapsed time in seconds used when rendering a region.

ROWS_FETCHED:
Shows the number of rows fetched by the Oracle Application Express reporting engine (the page size).

TOTAL_ROWS:
Displays the total number of rows that satisfy a SQL query used for a report.
Note: this is always 1 more than the actual number of rows. So when 0 rows are returned, TOTAL_ROWS is 1.

FIRST_ROW_FETCHED: 1
LAST_ROW_FETCHED:
Display the range of rows displayed.
For example: Row(s) 1 through of displayed

************************************************************

Method to use the substitution strings from the Region Footer of (interactive) reports for other purposes.

In the example above, the #TOTAL_ROWS#; substitution string is used to fill page item P1009_REPORT_TOTAL_ROWS, using jquery.
The value of this page item can then be used in dynamic actions, e.g. to show/hide other items.
Note: Make sure that in your page template, the javascript substitution strings listed below are located in the Header and not in the Footer.
E.g. in Theme 42 of Apex 5.0 these are located in the footer, resulting in Javascript error "ReferenceError: $s is not defined".

#APEX_JAVASCRIPT#
#THEME_JAVASCRIPT#
#TEMPLATE_JAVASCRIPT#
#APPLICATION_JAVASCRIPT#
#PAGE_JAVASCRIPT# 

Item P1009_REPORT_ROWS_SHOWN contains the number of rows that are actually displayed in an Interactive Report; it is not useful for Classic Reports.
The number of rows displayed changes whenever e.g. using filters or changing the number of rows of the IR. Those types of IR actions have no effect on the substitution strings, since they refresh the report itself using PPR (Partial Page Refresh) and not the footer that contains the substitution strings.

Dynamic Actions

P1009_REPORT_ROWS_SHOWN (2x):
Note that we need 2 versions, because the class we are searching for got a new name in Apex 5.
Note also that you will probably need to substitute "LINK" for another column header, one that exist in your report and that cannot be hidden by the user.

To use P1009_REPORT_TOTAL_ROW, create true/false actions to show/hide items (or to perform any other actions you want).

Page

Identification
	Page ID	1009
	Name	Apex - Reports - Substitution Strings

Region

Identification
	Sequence	20
	Title	IR
	Type	Interactive Report
Source
	Source Type	DYNAMIC_QUERY
	Region Source	select emp.* from emp
Header And Footer
	Region Footer	<br/> ************************************************************<br/> <br/> TIMING: #TIMING# sec.<br/> Shows the elapsed time in seconds used when rendering a region.<br/> <br/> ROWS_FETCHED: #ROWS_FETCHED#<br/> Shows the number of rows fetched by the Oracle Application Express reporting engine (the page size).<br/> <br/> TOTAL_ROWS: <span id="span_total_rows_id">#TOTAL_ROWS#</span><br/> Displays the total number of rows that satisfy a SQL query used for a report.<br/> Note: this is always 1 more than the actual number of rows. So when 0 rows are returned, TOTAL_ROWS is 1.<br/> <br/> FIRST_ROW_FETCHED: #FIRST_ROW_FETCHED#<br/> LAST_ROW_FETCHED: #LAST_ROW_FETCHED#<br/> Display the range of rows displayed.<br/> For example: Row(s) #FIRST_ROW_FETCHED# through #LAST_ROW_FETCHED# of #ROWS_FETCHED# displayed<br/> <br/> ************************************************************ <script type="text/javascript">$s("P1009_REPORT_TOTAL_ROWS", "#TOTAL_ROWS#");</script>

Item

Identification
	Sequence	10
	Name	P1009_REPORT_TOTAL_ROWS
	Display As	Number Field
User Interface
	Region	IR
Advanced
	Custom Attributes	disabled="disabled"
	Warn on Unsaved Changes	Page Default

Item

Identification
	Sequence	20
	Name	P1009_REPORT_ROWS_SHOWN
	Display As	Number Field
User Interface
	Region	IR
Advanced
	Custom Attributes	disabled="disabled"
	Warn on Unsaved Changes	Page Default

Dynamic Action

Identification
	Name	fill P1009_REPORT_ROWS_SHOWN (Apex < 5)
Execution Options
	Sequence	10
When
	Event	After Refresh
	Selection Type	Region
	Region	IR
Server-Side Condition
	Type	Exists (SQL query returns at least one row)
	Expression 1	select s from ( select to_number(substr(version_no, 1, instr(version_no,'.')-1)) as s from apex_release ) where s < 5
Advanced
	Event Scope	Dynamic
True Action
Identification
	Action	Execute JavaScript Code
Settings
	Code	$s('P1009_REPORT_ROWS_SHOWN', $('.apexir_WORKSHEET_DATA td[headers="EMPNO"]').length);
Execution Options
	Sequence	10
	Fire On Initialization	Yes

Dynamic Action

Identification
	Name	fill P1009_REPORT_ROWS_SHOWN (Apex >= 5)
Execution Options
	Sequence	20
When
	Event	After Refresh
	Selection Type	Region
	Region	IR
Server-Side Condition
	Type	Exists (SQL query returns at least one row)
	Expression 1	select s from ( select to_number(substr(version_no, 1, instr(version_no,'.')-1)) as s from apex_release ) where s >= 5
Advanced
	Event Scope	Dynamic
True Action
Identification
	Action	Execute JavaScript Code
Settings
	Code	$s('P1009_REPORT_ROWS_SHOWN', $('.a-IRR-table td[headers="EMPNO"]').length);
Execution Options
	Sequence	10
	Fire On Initialization	Yes

Dynamic Action

Identification
	Name	update P1009_REPORT_TOTAL_ROWS
Execution Options
	Sequence	30
When
	Event	After Refresh
	Selection Type	Region
	Region	IR
Advanced
	Event Scope	Static
True Action
Identification
	Action	Execute JavaScript Code
Settings
	Code	$s('P1009_REPORT_TOTAL_ROWS', $('span_total_rows_id').text);
Execution Options
	Sequence	20
	Fire On Initialization	No
Affected Elements
	Selection Type	Item
	Item(s)	P1009_REPORT_TOTAL_ROWS