Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set default sort order for reports?

Blue BirdOct 6 2016 — edited Oct 7 2016

I have a created Form on Table with Report. I would like to know how I can define default (by design) sort order for records displayed on Interactive report? For example I used for that report in Source > SQL Query appropriate Sort clause but records at run time are not  displayed in that order on report. Why not? I know I can set sort order later on actual report with Actions > Format > Sort, but then I already see visual icon on column name by which column is sorted. How to define defult sort in query or code without using Sort option on actual displayed report?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2016
Added on Oct 6 2016
3 comments
2,540 views