APEX 5 interactive report column order

Question

I have an issue with changing interactive report column order. My APEX version 5.0.3.00.03.

If i change order in Columns nothing change. If i change order in SqlQuery nothing change. If i change type of report (eg select classic report) and come back to interactive order finally change.

I'm doing wrong or there is a bug?

Answer 1

So what we can do here is, once you run your report and see the output.

Click on "Action" button on your report output, near the Search bar. Then choose "columns". No in the next pop up window, you can reorder the columns and even opt to not show some of the column. Once you are done with the changes, click on "Apply".

Now you need to follow these steps to make these changes default for all. Actions --> Reports --> Save Report --> Choose "As Default Report Settings" in save drop down menu --> Apply.

Now your changes will be done and saved as default for all.