New columns not shown in Interactive Reports

By Default APEX Interactive Report doesn’t show new columns after the report is created. It bothered me a lot. Usually I need to delete the report and do it all over again just to add new columns!

I finally find the solution today!

e.g.
If original query:

select
first_name
 , age
from users;

is changed to:

select
   first_name
 , age
 , job
from users;

Refresh the report page and the “job” column is not shown.

Do the following 6 steps to fix this:

1. Login to APEX with Developer privileges.
2. Run the report.
3. Click the gear icon, choose “Select Columns” and you will find the missing column on the left. Select & move them to the right.
4. Click Apply.
5. Then click on the gear icon again, click “Save Report”, choose “As Default Report”.
6. Click Apply.

Advertisement