4 Replies Latest reply on Jul 11, 2018 9:26 AM by SACH!N-Oracle

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

SACH!N-Oracle Jul 11, 2018 8:45 AM

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

1. Re: 'Maximum rows per page' page attribute value is not reflecting after setting it's value

fac586 Jul 11, 2018 8:51 AM (in response to SACH!N-Oracle)

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.
Like Show 0 Likes(0)

Actions
2. Re: 'Maximum rows per page' page attribute value is not reflecting after setting it's value

SACH!N-Oracle Jul 11, 2018 8:58 AM (in response to fac586)

It's an interactive report region.

Thanks,
Sachin
Like Show 0 Likes(0)

Actions
3. Re: 'Maximum rows per page' page attribute value is not reflecting after setting it's value

fac586 Jul 11, 2018 9:05 AM (in response to SACH!N-Oracle)

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
Like Show 0 Likes(0)

Actions
4. Re: 'Maximum rows per page' page attribute value is not reflecting after setting it's value

SACH!N-Oracle Jul 11, 2018 9:26 AM (in response to fac586)

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
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.