I am using Apex 3.2
I need to get the number of rows returned for a report into a page item, so I can use it in my logging. It could be classic or interactive.
I don't really want to just do a select count(*) on my report.
I have seen #TOTAL_ROWS# used, but only in a report footer.
How do I get this in to a page item.
Or is there a built in substitution string like (APP_ID, APP_USER) that I don't know about.
It didn't work properly on the interactive report (at least version 4.0.2), the total number of rows was wrong.
#ROWS_FETCHED# -- Shows the number of rows fetched by the reporting engine (the page size). Use these substitution strings to display customized messages to the user. #TOTAL_ROWS# -- Displays the total number of rows that satisfy a SQL query used for a report. For example, "X" in "rows X - Y of Z" #FIRST_ROW_FETCHED# -- The "X" in "rows X - Y of Z" #LAST_ROW_FETCHED# -- The "Y" in "rows X - Y of Z"