OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Rows drop list does not match interactive report number of rows

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Rows drop list does not match interactive report number of rows (APEX 4.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rows drop list does not match interactive report number of rows [message #660082]

Wed, 08 February 2017 10:15

Janning
Messages: 43
Registered: April 2016

Member

I have an interactive report, that is displaying 15 in the Rows drop down box, even though there are 39 rows in the output. I would like this to default to 50 rows, but can not find a way to do this.
Please advise

Report message to a moderator

Re: Rows drop list does not match interactive report number of rows [message #660083 is a reply to message #660082]

Wed, 08 February 2017 10:19

Janning
Messages: 43
Registered: April 2016

Member

http://www.aanning.com/ajissues_APEX/display_rows_issue/rows1s.jpg

[Updated on: Wed, 08 February 2017 10:19]

Report message to a moderator

Re: Rows drop list does not match interactive report number of rows [message #660085 is a reply to message #660083]

Wed, 08 February 2017 11:17

Janning
Messages: 43
Registered: April 2016

Member

It should be noted, I have already tried changing the report drop down to 50, and saving as the default report, it does not save for some reason

Report message to a moderator

Re: Rows drop list does not match interactive report number of rows [message #660091 is a reply to message #660085]

Wed, 08 February 2017 14:11

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I believe it does, but not in current session. Do it again (i.e. in Actions menu, set number of rows to 50; save the default report). Then log off, close web browser you use to develop the application. Start it once again, log on, run the IR. Any improvement?

[Updated on: Wed, 08 February 2017 14:11]

Report message to a moderator

Re: Rows drop list does not match interactive report number of rows [message #660092 is a reply to message #660091]

Wed, 08 February 2017 14:42

Janning
Messages: 43
Registered: April 2016

Member

I did this, and logged out and closed browser and came back in. It comes up default as 50 in the drop down, as soon as I filter on a user (that has 35 records), it goes to 15 again.

Report message to a moderator

Re: Rows drop list does not match interactive report number of rows [message #660094 is a reply to message #660092]

Wed, 08 February 2017 15:50

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Hm. Sounds like a bug.

Did you try to set number of rows in reports' attributes (i.e. that can be set during design)? I think there's such a property (but I can't remember whether it makes sense for a classic or an interactive report, and I can't check it right now).

Report message to a moderator

Re: Rows drop list does not match interactive report number of rows [message #660095 is a reply to message #660094]

Wed, 08 February 2017 15:54

Janning
Messages: 43
Registered: April 2016

Member

Interactive reports do not have this attribute.

Report message to a moderator

Re: Rows drop list does not match interactive report number of rows [message #660101 is a reply to message #660095]

Thu, 09 February 2017 00:10

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How about this: create a (hidden) item on a page, say P1_MAX_ROWS and set it to 50. On the attributes page, set that item to be source for the "Maximum rows per page" property:

&P1_MAX_ROWS.

(literally like that: ampersand followed by item name followed by dot).

Report message to a moderator

Previous Topic:	Prevent line wrap in field on APEX page
Next Topic:	Lock and unlock an APEX workspace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 14:30:04 CST 2025