I have a requirement wherein I need to conditionally hide/ unhide the button on an interactive report.
In order to achieve this, I need to compare the number of reows fetched per page v/s number of rows to be
fetched as specified by the user (Actions -> Rows per page).
Please help me to know if there is a way to capture these 2 values:
1. Number of records fetched per page in a report
2. The value set by the user for number of rows to be fetched (Actions -> Rows per page).
Quick help is really appreciated. Thanks.
You could probably use a similar technique to this
Grassroots Oracle: Count number of rows returned in APEX report
You can use this by jariola in his blog