Oracle Version is 4.2 this is an Interective Report.
The problem is because we have alot of data and when I run the report click the Action button, go to page per rows in the context menu and change that to 100, APEX will freeze while trying to process this and it will take forever and it is painful to watch taking all day whithout changing. The page freezes all the time so this process doesn't work for us for this particular application. I can do it for other application that doesn't access data that are over a 6000 rows. So for now I need the mechanism to change the rows through pagination attribute and here I don't have much to work with.
To set the number of rows shown as default to an other value than 15.
- If the action menu is not active for the interactive report activate it. Make sure "Rows Per Page" and "Save Report" are checked.
- Now run the page and use the Action menu > Rows per page to set the number of rows you want.
- Save the report again trough the action menu.
- When prompted choose save "As Default report settings".
- And then choose "Primary"
The default number of rows displayed is now permanent changed.
If the users arenot allowed to use the action menu you can now deactivate it again.
The saving of the report as default report settings works for other action menu settings as well.
I agree, but this strategy is not working for us because of the volume of the data in the database. Once you select the number of rows per page in Action menu, APEX will try to process that event to set the rows to 100, then this will take forever and freeze because APEX is trying to process the data. I did this in a smaller application (DMA) and it works. I can print 100 roows per page but not in the Application (ADC) I am trying to solve this issue. Another issue I will unticipate, is that every time we will deploy the application we will go through this issue.Because when we do a new deployment, the new deployment will reset the report to the original report so I will have to set rows to 100 and save the report again.
IS there any solution that is best then this? My question is that why Developer at Oracle didn't allow a developer to set the number at development as developer will set the maximun number on pagination section? where the initial 15 rows is in the application with Next icon? I have been searching for the initial 15 rows on report can someone tell me where I can find that so I can change it to 100?