Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Number of Rows Returned For A Report

Gus CAug 2 2012 — edited Aug 2 2012
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.

Cheers

Gus

Edited by: Gus C on Aug 2, 2012 12:31 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 30 2012
Added on Aug 2 2012
8 comments
4,397 views