Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

about reports sorting

Former Member

‎02-07-2008 4:57 PM

0 Kudos

Hi ,

i have three fields field1 , field2 , field3 .They are from some database table.

i want to prepare a report that field1 values are in ascending order and field2 values are in descending order and field values are in ascending order .

Thanks in advance.

2 REPLIES 2

laxmanakumar_appana
Active Contributor

‎02-07-2008 5:07 PM

0 Kudos

Hi,

Use below statement to do sorting as per your req.

SORT i_tab BY field1 ASCENDING field2 DESENDING field3 ASCENDING.

Regards

L Appana

Former Member

‎02-07-2008 5:09 PM

0 Kudos

Hi Kaladhar,

Store those values in an internal table

then SORT ITAB BY FIELD1 FIELD3 ASCENDING FIELD2 DESCENDING.