Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Rows drop list does not match interactive report number of rows (APEX 4.2)
Rows drop list does not match interactive report number of rows [message #660082] Wed, 08 February 2017 10:15 Go to next message
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
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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).
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 Go to previous messageGo to next message
Janning
Messages: 43
Registered: April 2016
Member

Interactive reports do not have this attribute.
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 Go to previous message
Littlefoot
Messages: 21806
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).
Previous Topic: Prevent line wrap in field on APEX page
Next Topic: Lock and unlock an APEX workspace
Goto Forum:
  


Current Time: Thu Mar 28 07:36:24 CDT 2024