Skip to Main Content
Forums

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!

'Maximum rows per page' page attribute value is not reflecting after setting it's value

SACH!N-OracleJul 11 2018 — edited Jul 11 2018

Hi,

In my apex report, even after setting the 'maximum rows per page' value to 20, I'm able to see all the 29 rows.

I'm using Universal Theme - 42 with tab based navigation.

Apex version i'm using is apex 18.1.

Is this a bug or do i need to set any other attribute in 18.1 release ?

Please let me know if more information is required.

Please help/advise.

Thanks,

Sachin
This post has been answered by SACH!N-Oracle on Jul 11 2018
Jump to Answer

Comments

fac586 
SACH!N-Oracle wrote:
In my apex report, even after setting the 'maximum rows per page' value to 20, I'm able to see all the 29 rows.
I'm using Universal Theme - 42 with tab based navigation.
Apex version i'm using is apex 18.1.
Is this a bug or do i need to set any other attribute in 18.1 release ?

What do you mean by "apex report"? Always specify clearly and unambiguously exactly which APEX region or component type you are referring to.

SACH!N-Oracle

It's an interactive report region.

Thanks,

Sachin

fac586 
SACH!N-Oracle wrote:
It's an interactive report region.

Read the online help for the Maximum Rows Per Page property:

Maximum Rows Per Page
Enter the maximum number to display in the Rows Per Page selector.

It would appear that it doesn't do what you think it does. Are you confusing it with the Maximum Rows to Process property in the Performance section of the property sheet?

1 person found this helpful
SACH!N-Oracle
Answer

Yes i'm aware of that property.

I'm not sure whether it's an apex or my browser's (Mozilla) bug, the 'Maximum Rows Per Page' count, which i had given for my IR region (maximum 20 rows per page) was not reflecting.

Later when i changed a few other IR region attribute values it worked for me. I'll explain.

Earlier the IR region 'Heading' property was set as 'Fixed To: Page'

I changed it to 'Fixed To: Region' and also gave the 'Maximum Report Height' value.

After changing the above attribute values and reloading the IR report page, to my surprise i found that the 'Maximum Rows Per Page' property was working (only 20 rows were displayed).

Later i reverted the IR region 'Heading' property as 'Fixed To: Page' and reloaded the page, i found the 'Maximum Rows Per Page' property is working.

Someway the issue got resolved, but as i mentioned earlier, still I'm not sure whether it's an apex or my browser's (Mozilla) bug or some sort of cache issue.

Thanks,
Sachin

Marked as Answer by SACH!N-Oracle · Sep 27 2020
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 8 2018
Added on Jul 11 2018
#apex-discussions
4 comments
141 views