LAZY LOADING

Requirement:
Lazy loading in Oracle Apex

Step1:
Create a page

Step 2:
Create a report region

Step 3:
Create a hidden page item
Ex : P1_HIDDEN

Step 4:
Create on- load before header PL/SQL process and assign the value ‘N’
for that hidden item.

Step 5:
In report query add the condition as :P1_HIDDEN=’J’

Step 6:
Create a dynamic action on page load, with the following true actions
1. Set the value ‘J’ for hidden item.
2. Submit the value of hidden item.
3. Refresh the report region.

By 
Preethi J